709609_en-US

liliconcom

JSL to create formula column with variable column names

Hi,

I need to create a new formula column via script using variables for column names and constant.

Tried various combinations of Expr, Eval, Parse, Eval Insert for no avail.

See sample.

Thanks

row = 11;
col = "foo";

for (i = 1, i <= ncols(dt), i++,
dt << New Column( "ratio " || char(i), numeric,
formula(( column(col) - column(col)[row] ) / (Col Max(col) - Col Min(col))));
);

Automation and Scripting