topic Re: Rerun Transfrom Column in Discussions

Rerun Transfrom Column

hogi — Sun, 10 Sep 2023 10:05:32 GMT

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:

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)});

Re: Rerun Transfrom Column

hogi — Wed, 13 Sep 2023 11:52:11 GMT

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:

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

Re: Rerun Transfrom Column

hogi — Wed, 13 Sep 2023 11:00:26 GMT

nobody?

Re: Rerun Transfrom Column

jthi — Wed, 13 Sep 2023 11:32:33 GMT

<< Reset Transform() maybe

Re: Rerun Transfrom Column

hogi — Wed, 13 Sep 2023 11:51:29 GMT

nice :)

and

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