topic Re: Equations to open in new data table in Discussions

Equations to open in new data table

JMPUser9 — Mon, 26 Jun 2023 16:42:10 GMT

I need to calculate two separate equations to open in two columns in a new data table. Is there a way to do so?

Re: Equations to open in new data table

Jed_Campbell — Mon, 26 Jun 2023 21:18:42 GMT

Yes, but we'll need more specifics to give a useful answer. What steps do you need to take, and are you looking for a scripting answer, or one that can be accomplished in the GUI?

Re: Equations to open in new data table

txnelson — Mon, 26 Jun 2023 21:48:18 GMT

Is this what you are talking about. This script creates 2 new columns, each with a different formula:

Names Default To Here( 1 );
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "one", formula( :height + :weight ) );
dt << New Column( "two", formula( :height / :weight ) );

Re: Equations to open in new data table

JMPUser9 — Fri, 30 Jun 2023 14:25:36 GMT

Jim, thanks for the feedback. I'm looking to run a script where

select where name is Katie and Tim, then height = 59 + 60

In a new table

Names Height Sum

Katie/Tim 119

And then any combinations I specifically call out.

Re: Equations to open in new data table

txnelson — Fri, 30 Jun 2023 16:56:08 GMT

Here is a simple script that provides one solution

Names Default To Here( 1 );
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

theNames = {"KATIE", "TIM"};
theRows = dt << get rows where( dt:name == theNames[1] | dt:name == theNames[2] );

If( N Items( theRows ) == 2,
	dt2 = New Table( "Results" );
	dt2 << add rows( 1 );
	New Column( "Names", character, set each value( theNames[1] || "/" || theNames[2] ) );
	New Column( "Height Sum", set each value( Sum( dt:height[theRows] ) ) );
	Try( dt2 << delete columns( "Column 1" ) );
);