I have used virtual join on 2 tables with no issue.
When I try to bring in a third table it will not let me because a column can only have 1 linked reference.
Without adding redundant columns, is it possible to virtual join 3+ data tables?
Thanks for your help.
As far as I know there is no maximum number of data tables that can be virtually joined. Here's the online documentation link:
One key to virtually joining data tables is noting that there is only one link reference column in the main data table, which in turn facilitates virtually connecting to all the other auxiliary data tables which use the link ID column. So it's through this chain of link ID columns that bring all the auxiliary data tables to the main data table.
Did you see the example in the JMP online documentation in the Notes: section on this page? It's an example of virtually joining 3 data tables.
Yes, in the example there are 3 tables virtually joined together. But the problem is that they use 2 columns for linked reference. See the blue keys in the picture below.
I would like to use only one column to link reference multiple tables.
I know it is possible to virtually join N tables if I use N -1 columns. But I would prefer not to have N - 1 duplicate columns.
There are no labels assigned to this post.