Replace a value in a table via ironpython

[David Katz]

In a table view, there's the option "Replace Value" in the right-click pop-up menu.

Can this be done from an IronPython Script? I want to change the value in a set of marked rows.

Thanks.

[Fredrik Rosell]

Hello,

Yes, it's simply a transformation. You can read more about the Replace* Transformations here: 

ReplaceSpecificValueTransformation Class

Represents a DataTransformation that replaces values on specific rows, or on a single specific row.

https://docs.tibco.com/pub/doc_remote/sfire_dev/area/doc/api/TIB_sfire-analyst_api/?topic=html/T_Spotfire_Dxp_Data_Transformations_ReplaceSpecificValueTransformation.htm&_ga=2.83343446.157951067.1665987582-776196050.1636355826

ReplaceValuesTransformation Class

Represents a DataTransformation that replaces all values in a column that match a given value.

https://docs.tibco.com/pub/doc_remote/sfire_dev/area/doc/api/TIB_sfire-analyst_api/html/T_Spotfire_Dxp_Data_Transformations_ReplaceValuesTransformation.htm

If you take a look in the script example below, you can find an example of ReplaceValuesTransformation being used.

https://community.spotfire.com/s/article/How-to-Replace-a-Transformation-in-a-DataTable-in-TIBCO-Spotfire-Using-IronPython-Scripting

[David Katz]

Fredrick,

 

Thanks very much for this material.

 

Regards,

 

*David Katz*, TIBCO Data Science

 

 

1.541.324.7417

[David Katz]

Still needing help:

1) ReplaceSpecificValueTransformationClass seems to require the old value in the cell, even though we have already specified the row(s) and columns. Is that right? What I want is to mark the rows and then poke the new values in regardless of the old. How best to do that?

2) after I create the new transformation, is there an additional step to apply that transformation to the existing table?

Thanks much!