Accessing all columns in a Project with multiple files and same indexI have a project with three tables (A, B, C) which I am using to create a virtual join.
- A:index < Reference
- B:index < Linked with A:index
- c: index < Linked with A:index
From B and C, I can see A columns, but how I can see from A all the columns?
In general, what I would like is to access all columns with the Graph Builder.
Data TableGraphicsRe: Accessing all columns in a Project with multiple files and same indexHi,
You need to "pass through": A --> B --> C
c:index --> set "Link ID" property. Note there can be no repeated values.
b:index --> set as Link ID, AND set as reference to table c. Here also, there can be no repeated values.
a:index --> set as Link Reference, pointing to table B.
Note: prior to JMP 15, columns could not simultaneously serve as both link ID and link Reference, so an additional "dummy" column must be created in each table thru which you intend to pass.
Cheers,
Brady
Re: Accessing all columns in a Project with multiple files and same indexThanks. Can we do this with two tables only?
A tried creating dummy columns (using formulas) but I get the following error:
Circular reference detected.
Column Index of Datatable_A references back to Datatable_B
The offending column has been marked 'EXCLUDE'.
