cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Tavuk89
Tavuk89
Level II

Merge multiple tables corresponding to different column in main table

Dec 12, 2023 06:49 PM (780 views)

I have main table and multiple others that I would like to join with that.

The main table has column A that corresponds to first table,

column B that corresponds to 2nd table

column C that corresponds to 3rd table

These tables also have columns with same name, so I don't want to merge column with same name together.

I usually join these tables one by one. How do I join them at once? I don't know how to write jsl script..

0 Kudos
2 REPLIES 2
txnelson
Super User txnelson
Super User

Re: Merge multiple tables corresponding to different column in main table

Dec 12, 2023 11:54 PM (770 views)  |  Posted in reply to message from Tavuk89 12-12-2023

I suggest that you take each of your interactive Join steps, and place them into a JMP Workflow.  Then once it is built, all you have to do is to run the Workflow whenever you need to join the tables.

Jim
0 Kudos
Tavuk89
Tavuk89
Level II

Re: Merge multiple tables corresponding to different column in main table

Dec 19, 2023 07:25 PM (718 views)  |  Posted in reply to message from txnelson 12-12-2023

Thank you but I'm still at JMP 16

But I learnt jsl scripts and scripted them all