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

Merge multiple tables corresponding to different column in main table

Tavuk89 — Tue, 12 Dec 2023 23:49:07 GMT

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

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

txnelson — Wed, 13 Dec 2023 04:54:46 GMT

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.

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

Tavuk89 — Wed, 20 Dec 2023 00:25:00 GMT

Thank you but I'm still at JMP 16

But I learnt jsl scripts and scripted them all :)