New Column Formula with JSL

Djtjhin

I'm trying to add new column formula to a table based on user input. The input can either be a single value or a column selection. 

Been trying couple methods but I couldn't get one which could handle this interchangeably. 

Sample script that I tried below.

 

Ideally I can keep the "newcolexpr" expression the same regardless of the input. This is mainly because I'm trying to deploy custom formula column which takes lots of inputs (i.e. >8 inputs)

 

Appreciate the help.

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

//when selection is a single value
//desired outcome: a new column "Test" with formula (1*5)
selection = {1};

newcolexpr = expr(
	dt << new column("Test", formula(expr(selection[1])*5))
);
eval(eval expr(newcolexpr));

//when selection is a column (e.g. "height")
//desired outcome: a new column "Test" with formula ("height"*5)
selection = {"height"};

newcolexpr = expr(
	dt << new column("Test", formula(expr(selection[1])*5))
);
eval(eval expr(newcolexpr));

jthi

Approaches on how to approach this depends a lot on the variables, inputs and formulas you have.

Other example:

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

formula_expr = Expr(Expr(dt << New Column("Test", Numeric, Formula(placeholder*5))));
selection = {1};
Eval(Substitute(formula_expr, Expr(placeholder), selection[1]));
selection = {:height};
Eval(Substitute(formula_expr, Expr(placeholder), selection[1]));

formula_expr2 = Expr(Expr(dt << New Column("Test", Numeric, Formula(Sum(placeholder)))));
selection = {1,3};
Eval(Substitute(formula_expr2, Expr(placeholder), selection));
selection = {:height, :weight};
Eval(Substitute(formula_expr2, Expr(placeholder), selection));

formula_expr3 = Expr(Expr(dt << New Column("Test", Numeric, Formula(Col Sum(placeholder)))));
selection = {:height, :age, :sex};
Eval(Substitute(formula_expr2, Expr(placeholder), selection));

Some links:

Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute 

Using list of columns in formulas 

Can you construct this without writing expression as a string?