Automate Calculated column in Spotfire

[Shubh M]

Hey Everyone

Happy new Year to Spotfire Community :-)

 

I need some help around creating calculated column/expression in Spotfire, which reads values from XLS source.

***********************************

Expression looks like:

Case

when ([Machine Name A] in ("123")) and ([startDate]>=Date(2019,8,22)) and ([startDate]=Date(2019,8,22)) and ([startDate]=Date(2019,11,3)) and ([startDate]=Date(2019,11,3)) and ([startDate]=Date(2019,9,5)) and ([startDate]=Date(2019,9,5)) and ([startDate]

[Rayees Wani]

In case this helps:

How to add a calculated column and add it in Table visualization in TIBCO Spotfire using an IronPython script:

https://community.spotfire.com/wiki/how-add-calculated-column-and-add-it-ta...

[Shubh M]

Thanks Rayees Wani, Let me explore this option and ill get back to you if I need anymore help/direction on this. Thanks 

[Shubh M]

Hey Rayees,

 

Thanks for your advice on calculating exression.

 

I have written this initial peice of code which gives me the required expression, but now i have few more follow up questions where i seek your help. 

 

how can we assign a script output to document property

how can we use one scripts output as input to another script

 

I basically need to add this script output as calculated column in data table. Let me know if any more details needed from my side. 

 

Many thanks in advance. 

 

Regards, Shubs