How to apply a formula to an existing column with a variable name?

natalie_ — Thu, 28 Jan 2016 15:37:49 GMT

Hi all,

I would like to apply the same formula to multiple existing columns in my data table using JSL.

I have one column that says 0V and the other that says RP_0V. I would like to apply a formula to column RP_0V using the 0V column. I have to do this many times (for column RP_10V using the column 10V, etc.)

I am having a lot of trouble figuring out the syntax for it, and I bet it is pretty simple...

for(i=0, i<=65, i++,

colName =Column(char(i*10)||"V");

dtSummary:("RP_"||char(i*10)||"V") = Formula(100*Col Rank(:colName)/1006);

);

Re: How to apply a formula to an existing column with a variable name?

natalie_ — Thu, 28 Jan 2016 16:24:37 GMT

I got it to work! My main problem was that I wasn't using AsColumn.

for(i=0, i<=0, i++,

colName =Column(char(i*10)||"V");

colRP=("RP_"||char(i*10)||"V");

Column(colRP) <<Formula((100*Col Rank(:AsColumn(colName))/(1006)));

);

topic Re: How to apply a formula to an existing column with a variable name? in Discussions

How to apply a formula to an existing column with a variable name?

Re: How to apply a formula to an existing column with a variable name?