How to merge more than 2 tables?

[#1]

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]

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.

[#3]

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.

[#4]

What type of join do wish to do? Do you have any columns you can join with? Or is it just row by row? If query builder isn't able to do what are looking for, you might have to do this by scripting Join platform (luckily it is simple but still it will require a script). If it is always the same join with the same amount of tables, you can most likely do this with the help of Workflow builder.

@mzwald do JMP tables support full outer join? https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/select-tables-from-a-sql-database.shtm...

To do a full join and import all rows, you would select Include non-matching rows from g1_charges. If only one of the non-matching options is available, the database does not support full joins.

Would be nice if query builder was able to tell what the gray-out means instead of leaving user guessing what they are doing wrong

[#5]

The gray-out "option" can only be activated for Database queries:

When you want to build a query from JMP data tables:

the option is always disabled:  Supported Join types for Table > JMP Query Builder 

If you need this option you can ask a community manager to reactivate this wish:

Add right and full outer joins to JMP Query Builder  ... and vote for it.