Applying if (document.property == True) then "Calculate and replace column"

[pratikpathak]

Hi everyone, I'm new to spotfire,

Recently I have run into an issue where i have to "calculate and replace column" dynamically i.e. based on environment variable/Document properties. I know I can apply transformation but I wanted to know How i can apply some condition and based on the condition apply different expression to create new column.

Thankyou and regards,
Pratik Pathak

[David Boot-Olazabal]

Hi Pratikpathak,

You may want to try one of these options with Iron Python scripting:

• (create new calculate column) How to add a calculated column and add it in table visualization
• (replace a transformation) How to replace a transformation in a datatable

Kind regards,

David