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.Thanksrow = 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))));
);