Concatenate strings to create variables within a formula

spudton — Sat, 10 Jun 2023 23:14:04 GMT

Hi,

beginner JMP user here,

I would like to create a new column "Tag Range" which has the formula in it "Tag.ULIMIT-Tag.LLIMIT".

Tag.ULIMIT and Tag.LLIMIT are columns in my data table.

I can create the column by explicitly defining the column names in the formula as below, but I would like to replace these with the variables "UpperLIMIT" and "LowerLIMIT".

(ultimately, I would like to run a script that creates this column based on the tag name selected by the user)

Names Default To Here( 1 );
a = "Tag";

UpperLIMIT = a || ".ULIMIT";
LowerLIMIT = a || ".LLIMIT";

dt = Current Data Table();

This works:

dt << New Column( a || " Range", formula( :Tag.ULIMIT - :Tag.LLIMIT ) );

this doesn;t work:

dt << New Column( a || " Range", formula( :UpperLIMIT - :LowerLIMIT ) );

Re: Concatenate strings to create variables within a formula

txnelson — Tue, 12 May 2020 12:41:11 GMT

JMP does not evaluate the statements within a "formula" definition prior to creating the formula. It assumes the formula is as it needs to be. Therefore the formula needs to be syntactically as needed when specified. The code below handles that for your example

Names Default To Here( 1 );
dt = Current Data Table();

a = "Tag";

UpperLIMIT = a || ".ULIMIT";
LowerLIMIT = a || ".LLIMIT";

Eval(
	Parse(
		"dt << New Column( \!"" || a || " Range\!", formula( :"
		 || UpperLIMIT || " - :" || LowerLIMIT || " ) )); "
	)
);

topic Re: Concatenate strings to create variables within a formula in Discussions

Concatenate strings to create variables within a formula

Re: Concatenate strings to create variables within a formula