Merging Multiple Tables

[#1]

Is there a way in JMP to join multiple tables at once. I have a very large data set and I need pick various data out of different rows and columns for various functions. I can do this with the built-in JMP Query Builder, then save the scripts for individual functions. However, this yields multiple data tables, all with one common column of data. Is there a way to have a script that joins all these tables at once based on the one common column? I'd like a script that I can have saved so I don't have to merge tables one at a time every time I do this.

[#2]

Assuming you have a list with the names of the tables you want to merge and that the column names are all the same, the concatenate() function should work for you. Example below that attempts to merge all open tables:

dtlist = {};

For( i = 1, i <= N Table(), i++,
	dt = data table(i);
	insert into(dtList, dt );
);

dtbigtable = concatenate (dtlist);

[#3]

Hi Jed,

Thank you for the quick response. That's close to what I'm looking for, but not quite. Unfortunately, that yields a table similar to the one below:

LargeChipmunk17_0-1669932796918.png

What I'm trying to achieve is more like what's shown below, so that I can use fit model with the data:

LargeChipmunk17_1-1669932863322.png

[#4 · Accepted solution]

You can use the Tabulate platform to get the table you need.

Jed_Campbell_0-1669933523856.png

(Data Table( "Untitled 148" ) << Tabulate(
	Add Table(
		Column Table( Analysis Columns( :Column 2, :Column 3, :Column 4, :Column 5 ) ),
		Row Table( Grouping Columns( :Column 1 ) )
	)
)) << Make Into Data Table

[#5]

Thank you that fixes my problem!