cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hogi
Level XI

Rerun Transfrom Column

To reevaluate the Formula of a Formula column, one can write

col<<Eval Formula()

Is there a similar command to re-evaluate a Transform Column?

Eval Formula doesn't seem to work here - Tcol1 still shows a curve with ::scalingFactor=1:

hogi_0-1694340250284.png

 

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
gb = dt << graph builder();

::scalingFactor= 1;
tC = dt << transform column ("TCol1",Formula( :height * ::scalingFactor ));

gb << variables(X(:height), Y(tC));

::scalingFactor=5;
tC << Eval Formula();

tC2 = dt << transform column ("TCol2",Formula( :height * ::scalingFactor ));
gb << add variable({tC2, Role("Y"), Position(1)});  

 

4 REPLIES 4
hogi
Level XI

Re: Rerun Transfrom Column

When the Transform Column is created by telling the data table to do so

 

col1 = dt << Transform Column ("col1Name", Formula(1/:height));

one can take the return value and sore it as a JSL symbol.

 

Then it's no problem to re-evaluate the formula:

 

col1<<Eval Formula()

 

 

The actual problem: 
If a report (e.g. graph builder) creates a transform column

 

gb = dt << graph builder();
gb << Transform Column ("col2Name", Formula(1/:height));

there is no return value: how to reference a Transform Column?

 

 

So, the question is reduced to:
How to update a a Transform Column which was created by a Report.

hogi
Level XI

Re: Rerun Transfrom Column

nobody?

jthi
Super User

Re: Rerun Transfrom Column

<< Reset Transform() maybe

jthi_0-1694604745325.png

 

-Jarmo
hogi
Level XI

Re: Rerun Transfrom Column

nice :)

and how to reference a Transform Column? 

... one which was generated from a Graph Builder object?