cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

Merge multiple tables corresponding to different column in main table

Tavuk89
Level II

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..

2 REPLIES 2
txnelson
Super User


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

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
Tavuk89
Level II


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

Thank you but I'm still at JMP 16

But I learnt jsl scripts and scripted them all