User Community
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: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 (1415 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 (1405 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 (1353 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 :)

Recommended Articles