topic JSL: How to copy a formula from one data table to another? in Discussions

JSL: How to copy a formula from one data table to another?

jumper — Fri, 28 Oct 2016 13:14:26 GMT

I need to copy a formula from one data table to another.

The only suggestion I found and managed to get to work is this:

The easiest way is to get the script for the original data table.

data table("Original") << get script;

Now the script appears in the log. Just copy and paste into a new script, keeping only the bits related to adding the the formula columns.

which seems, however, very convoluted and time-consuming when I need to apply it multiple times.

This other method was suggested here: Saving the prediction formula to an existing column?


f = column("prednew") << Get Formula;

column("predold") << Set Formula( Name Expr( f ));

so I tried:


f = data table("table 1") << column("my formula") << Get Formula;

data table("table 2") << column("my formula") << Set Formula( Name Expr( f ));

where 'my formula' already exists, but is empty, in table 2

but it doesn't work, and the log gives no errors.

Any ideas? Is this documented anywhere in JMP's official documentation?

Re: JSL: How to copy a formula from one data table to another?

ms — Sun, 12 Oct 2014 18:01:37 GMT

Get Formula() and Set Formula() are documented, whereas your syntax is probably not. Column() cannot be used as a message to a data table. Use instead the first argument of Column() to specify the data table.

f = Column( Data Table( "table 1" ), "my formula" ) << Get Formula;

Column( Data Table( "table 2" ), "my formula" ) << Set Formula( Name Expr( f ) );

Re: JSL: How to copy a formula from one data table to another?

ms — Sun, 12 Oct 2014 19:27:38 GMT

Another option is to use Get Column Properties() followed by Add Column Properties() to copy all properties, incl. formula. No need for Name Expr() when using this approach.

oldcol = Column( Data Table( "table 1" ), "my formula" );

newcol = Column( Data Table( "table 2" ), "my formula" );

newcol << Add Column Properties( oldcol << Get Column Properties() );

Re: JSL: How to copy a formula from one data table to another?

jumper — Mon, 13 Oct 2014 17:46:52 GMT

I couldn't get the method in your other post to work, but this works perfectly - thank you.

Re: JSL: How to copy a formula from one data table to another?

nascif_jmp — Mon, 25 Sep 2017 21:23:53 GMT

Coming a few years later to the party :)

You might also want to consider the Formula Depot, a feature added to JMP Pro 13, that is designed to help this kind of scenario.

It allows you to save (we call it "publish" in this case) a model (any formula, actually) to a central place from where it can be added to other tables - as well as converted to different languages for deployment, compared to other models, profiled, and so on.

Check it out:

http://www.jmp.com/support/help/13/Formula_Depot.shtml