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: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
View Translated Thread
Tavuk89
Tavuk89
Level II

Merge multiple tables corresponding to different column in main table

Dec 12, 2023 06:49 PM (1471 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 (1461 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 (1409 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