cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
LargeCamel26038
New Member

How to merge more than 2 tables?

I simply want to put the columns from each table in one table. I am able to do this by using join tables with just 2 tables but I want to join 4 tables at once. I have tried to use JMP query builder, but I cannot get it to join them.
2 REPLIES 2
mzwald
Staff

Re: How to merge more than 2 tables?

The JMP Query Builder from the Tables menu is how to join more than 2 tables in one step, so you are using the right platform.  Why it doesn't work could be due to several factors but usually it would be because you are doing an inner join on columns with no matching values.  Try changing the join to a full outer join, that should definitely return a result.

LargeCamel26038
New Member

Re: How to merge more than 2 tables?

Where is the option to do this? There is an option to include non matching rows from the second data table but it is greyed out and I am unable to select it.