I'm quite sure I will feel stupid after seeing the answers but I currently have a brain hang up.
I want to refer to a column from a list of columns in a new formula in JSL (for later looping over the list).
Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
mylist= dt<< Get Column Names();
dt << New Column( "myCol",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula(:height * mylist[1] )
);mylist[1] should later be the first column of the column list. I'm guessing I should wrap the list reference in an Expr() or Eval Expr(), but the functioning syntax escapes me at the moment.
Any help?
I'm fairly sure this post will help you solve the problem Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute .
The substitute was exactly was I was looking for, thank you!
