How to add lots of calculated columns at once

[Dayz Hsu]

Hi,

Iamcurrentlygettingfrustratedbyaddinglots ofcalculatedcolumns,

whichistakingso muchtimefor doingsuch arepeatthing.

WhenIsearchtheanswerforthis, Italwayscomesto"R"languagein"Register Data Functions",andnothingmore.

SinceIamtrulyanewbiehere,

couldsomebodyhelpmetosolvemyquestion or just give me some hinteitherinRor otherway

 

Reallyappreciated.

 

Hereismysimple,repeatformulawhichIamkeepingtyping/copypastenow:

SN([A] / AVG [A] over ([GROUP]),).

 

Thanksagain.

[David Boot-Olazabal]

Hi breadcanwork,

Please have a look at this post:https://community.spotfire.com/wiki/how-add-calculated-column-and-add-it-table-visualization-tibco-spotfirer-using-ironpython

It will show you how to use iron python to create a new calculated column. I assume you could repeat the steps described in there (in a single iron python script) to add more than one calculated column.

Kind regards,

David

[Dayz Hsu]

Thanks, I will study about that.