381975_en-US

liliconcom

Getting formula from column in a pretty format

I would like to obtain the formula of each column in a more readable format (also called pretty format).

 

For the example below I will like to obtain "height / weight".

 

Simply removing ":" will not work as columns can have such character.

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
col = New Column( "Ratio" );
col << Set Formula( :height / :weight );
col << Eval Formula;
result = col << Get Formula;
Show( result );

 <BR />// result = :height / :weight;

 

<BR />//&nbsp;desired_result&nbsp;=&nbsp;"height / weight";

 

ScriptingRe: Getting formula from column in a pretty format

Here is an example on how to do that

names default to here(1);
dt=open("$SAMPLE_DATA\big class.jmp");
dt<< new column("Example", formula(sqrt(:Height/:Age+:Weight*:Height)));

new window("pretty", expr as picture(dt:Example << get formula));

 

Re: Getting formula from column in a pretty format

JSL syntax requires colons to refer to columns, but there are other options such as what I show here.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << New Column( "Ratio", Set Formula( ascolumn("height") / ascolumn("weight")));

Not sure if it's more pretty though:)