Calling column from column list in formula

Feli — Fri, 09 Jun 2023 18:11:31 GMT

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?

Re: Calling column from column list in formula

jthi — Fri, 25 Feb 2022 09:07:38 GMT

I'm fairly sure this post will help you solve the problem .

Re: Calling column from column list in formula

Feli — Fri, 25 Feb 2022 09:31:25 GMT

The substitute was exactly was I was looking for, thank you!

topic Re: Calling column from column list in formula in Discussions

Calling column from column list in formula

Re: Calling column from column list in formula

Re: Calling column from column list in formula