Merging tables with virtual joins

KasperSchlosser — Thu, 27 Feb 2025 17:54:21 GMT

Hello JMP community

I was wondering if any had a solution to this problem.

the basic problem is just adding adding the columns from one data table to another, but with some caveats.

I have made some example data to illustrate the problem.

Here i have 2 data tables, each with some data and scripts. I now want to combine them into one big data table with everything

One problem is the name collision. so just copying the columns over, concatenating or the "update" option in tables would not work.

The best choice seem to be do a join, and this does work.

the formula columns still work, the name collision is handled and the saved table scripts are even updated to the changed column names.

Except the original tables were virtually joined to other tables.

this link is lost on joining the tables

simply adding the link back does not work, as the formula columns, that relied on a linked column, still refer to the old column

This example is quite simple, so just manually updating would be possible.

the real use case would be more complicated, so trying to fix the table after joining does not seem feasible.

b.r.

Kasper

Re: Merging tables with virtual joins

KasperSchlosser — Thu, 27 Feb 2025 17:56:56 GMT

and the data tables if someone needs them