How do I join tables?

shah47

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

 

txnelson

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