16553_en-US

liliconcom

How to apply a formula to an existing column with a variable name?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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?

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

);