How to skip calculate columns processing

[Vijesh]

Hi Team,

Is there a way to skip the calculate columns processing when opening spotfire report or is there a way to store calculated columns data in analysis . Have saved the report with below options but while loading report getting the message Calculate columns while loading analysis.

 

                   

 

                           

[Soumya.Goyal]

In general, when an analysis file is opened then calculated columns are refreshed by default to give the latest information. So there is no direct way to completely skip processing of calculated columns(even with the tables properties set above in yellow). However, if a workaround is needed then you can convert the calculated columns to Embedded data by exporting the file and then using it as a new data table in your analysis. This way the calculated columns will become static as well. The other way that I can suggest is to set up a ironpython script to control the data refresh only on demand.

I would also like to add that there is already a discussion going on to add a similar idea in Spotfire. Please feel free to go through the following link to know more- https://ideas.spotfire.com/ideas/TS-I-5376) 

[Vijesh]

Thanks Soumya for the response. We prefer the 2nd option i.e ironpython script to control the data refresh. 

In ironpython is there a way to disable calculated columns processing/computation? 

I can see options like how to refresh datatable (ReloadAllData, ReloadLinkedData, RefreshOnDemandData) or how to remove the expression in calculated column, disable calculated columns, remove calculated columns through Ironpython script. These option will not help us.

Not preferring 1st option because we have 88 calculated columns on single datatable which is formed using 10 csv files join. Converting 88 columns to embedded data requires re-design of 10 csv generation and visualizations. So not preferring this option now.