nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Merging Multiple Tables

LargeChipmunk17

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.

Accepted answers

Jed_Campbell

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

(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

All comments

Jed_Campbell

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

LargeChipmunk17

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:

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

Jed_Campbell

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

(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

LargeChipmunk17

Thank you that fixes my problem!