topic Re: How can I copy a new table data copy with column names to after the last column of another table in Discussions

How can I copy a new table data copy with column names to after the last column of another table?

lwx228 — Thu, 30 Aug 2018 10:16:06 GMT

For example, the Boston Housing.jmp Summary calculation produces a new table that wants to copy all the column names and data from the new table to the first row after the last column of Boston Housing.jmp.Thank you very much!

dt = Open( "$SAMPLE_DATA/Boston Housing.jmp" );
dt << Summary(
Group( :chas, :tax ),
Mean( :mvalue ),
Subgroup( :radial ),
Freq( "None" ),
Weight( "None" )
)

……？？

Re: How can I copy a new table data copy with column names to after the last column of another table

lwx228 — Tue, 21 Aug 2018 10:38:22 GMT

Re: How can I copy a new table data copy with column names to after the last column of another table

ian_jmp — Tue, 21 Aug 2018 14:06:03 GMT

I'm not sure that putting summary and raw data in the same table is necessarily a good idea. But, if you need to for some reason (and if I have understood correctly), then you can use 'Tables > Join' with 'By Row Number'. In JSL:

Names Default To Here( 1 );

// First table
dt1 = Open( "$SAMPLE_DATA/Boston Housing.jmp" );

// Summary table
dt2 = dt1 << Summary(
	Group( :chas, :tax ),
	Mean( :mvalue ),
	Subgroup( :radial ),
	Freq( "None" ),
	Weight( "None" )
);

// Joined table
dt3 = dt1 << Join( With( dt2 ), By Row Number, Output Table( "Joined Data" ) );

Re: How can I copy a new table data copy with column names to after the last column of another table

lwx228 — Tue, 21 Aug 2018 14:11:46 GMT

Excellent answer, thank you!

Re: How can I copy a new table data copy with column names to after the last column of another table

Thomas1 — Thu, 30 Aug 2018 07:56:28 GMT

Hi Ian,

this is an interesting topic. Is there away to add the summary data table to the source data table in order to have only one file (script table)?

What JSL must be applied to add the resulting means in one column and the N Rows as well in another column to the source data table?

The main interest here is to keep the summary data results in the origin source data table.