How to change the column data type in the script with IronPython

[L Zhong]

Hi All,

Do you know how tochange the column data type in the script with IronPython I've searched for quite a long time and no one method works.

Could you provide a simple example

Thank you so much!

 

Best Regards

LZ

[Rayees Wani]

Looks like the DataColumn. DataType Property is a Read only one and may not be set at Run time.

https://docs.tibco.com/pub/doc_remote/sfire_dev/area/doc/api/TIB_sfire-a...

However below link has a few suggestions that you may want to try:

https://community.spotfire.com/questions/changing-datatype-column-using-iro...

[Hector Martinez 2]

Here is an example:

from Spotfire.Dxp.Data.Transformations import ExpressionTransformation,ColumnSelection

 

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

t = ExpressionTransformation()

t.ColumnReplacements.Add(

'myColumnName',

'real([myColumnName])',

ColumnSelection('myColumnName')

)

table.AddTransformation(t)

print("Done Changing Datatypes....")