Subscribe Bookmark RSS Feed

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

natalie_

Community Trekker

Joined:

Jan 6, 2016

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);

);

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

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)));

);

1 REPLY
Solution

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)));

);