How to get column names using ironpython

[Marcio Souza]

Hi there!

Is there any way to get column names from a data table and put them in a list using IronPython

Cheers,

Marcio

[Shandilya Peddi]

The following script can help,

from Spotfire.Dxp.Data import *

 

colNames=[]

 

table=Document.Data.Tables["myTableName"]

for col in table.Columns:

colNames.append[col.Name]

[Manoj Singh]

from Spotfire.Dxp.Data import *

for eColumn in eDataTable.Columns:

 

print eDataTable.Name + "tColumn: " + eColumn.Name

[Marcio Souza]

I got the following error running the suggested script.

 

Traceback (most recent call last):  File "<string>", line 7, in <module>TypeError: 'builtin_function_or_method' object is not subscriptableIronPython.Runtime.Exceptions.TypeErrorException: 'builtin_function_or_method' object is not subscriptable   at CallSite.Target(Closure , CallSite , Object , Object )

 Where line 7 is :  colNames.append[col.Name]Any idea

[Marcio Souza]

I have noticed the issue. line 7 should be: colNames.append(col.Name) not  colNames.append[col.Name]

 

i have replaced [] by () and works.

 

Thanks!

[Senthilnathan Eswaran]

The below code is working fine. But I tried to save the column names into the document property. It won't save. Please suggest here!!

from Spotfire.Dxp.Data import *

colNames=[]

table=Document.Data.Tables["DataTableName"]

for col in table.Columns:

colNames.append(col.Name)

Document.Properties['TestName'] == colNames

print colNames

Example Output:

['EEID', 'Full Name', 'Job Title', 'Department', 'Business Unit', 'Gender', 'Ethnicity', 'Age', 'Hire Date', 'Annual Salary', 'Bonus %', 'Country', 'City', 'Exit Date', 'AutoBinNumeric Test', 'Base64Decode']