BookmarkSubscribe
Choose Language Hide Translation Bar
shah47
Occasional Contributor

How do I join tables?

I'm new to JMP and I'm trying to have the Summary Stats appear in the same table as my Current table with script, can someone let me know what I'm doing wrong?

 

 

dt = Current Data Table();
summDt = dt << Summary(
	Group( :Sample Number ),
	Subgroup(),
	Max( :Normalized Response ),
	Min( :Normalized Response ),
	Mean( :Normalized Response ),
	Std Dev( :Normalized Response ),
	Output Table Name( "Summary" )
);

dt << Join( With( "Summary" ) );
Output Table Name( "Joined" );

 

0 Kudos
2 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson
Super User

Re: How do I join tables?

The easiest way to get the JSL do do these kind of things, is to run the Platform, in this case the Join Platform, and then Edit the "Source" table entry in the new data table.  It will have the JSL that was used to generate the new table.

In your case, you have a spelling error:

dt << Join(
With( summDt)),
Output Table ( "Joined" ));
// or
dt << Join( With(data table("Summary"), Output Table("Joined"));
Jim
Highlighted
txnelson
Super User

Re: How do I join tables?

No Save is not quoted value.  The syntax should be

close( data table( "Summary" ), nosave );
Jim
3 REPLIES 3
txnelson
Super User

Re: How do I join tables?

The easiest way to get the JSL do do these kind of things, is to run the Platform, in this case the Join Platform, and then Edit the "Source" table entry in the new data table.  It will have the JSL that was used to generate the new table.

In your case, you have a spelling error:

dt << Join(
With( summDt)),
Output Table ( "Joined" ));
// or
dt << Join( With(data table("Summary"), Output Table("Joined"));
Jim
shah47
Occasional Contributor

Re: How do I join tables?

Thank You, that seems to work. My follw up is if I wanted to close the Summary table why does the script below not work?

 

Close( data table( "Summary"), "No Save");

0 Kudos
Highlighted
txnelson
Super User

Re: How do I join tables?

No Save is not quoted value.  The syntax should be

close( data table( "Summary" ), nosave );
Jim