Use a Variable for a column in Set Formula()<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />Using JMP 9.0.2 on Windows XP 32Bit
I want to produce a script which sets the formula of the column "Formula Column" to <<(:My Column) + 1>>. I need to reference "My Column" with a variable though. The following script makes the formula <> which is meaningless...
col = column("My Column");
:Formula Column<Re: Use a Variable for a column in Set Formula()
Yes, I noticed and removed the post quickly. Sorry for the confusion. Formula(Ascolumn(col)...) only works as long the global col is not cleared.
Re: Use a Variable for a column in Set Formula()The only problem with this approach is that is leaves the formula in the 'Formula Column' as <>, which only works as long as col=Column("height");. It would be much nicer if the formula changed to <<:height + 1>> so that it worked even if 'col' is being used for something else. Maybe too much to ask...
Re: Use a Variable for a column in Set Formula()Thanks. For me I just needed:
newcol=dt<<new column("Formula Column", formula(eval((parse(col))+1)));
Re: Use a Variable for a column in Set Formula()There may be a simpler way, but this works in JMP 9 (Mac):
dt = Open("$ENGLISH_SAMPLE_DATA/Big Class.jmp");
col=Column("height")<<get name;
newcol=dt<<new column("Formula Column", formula(eval(evalexpr(expr(parse(col))+1))));
