Accessing all columns in a Project with multiple files and same index

Question

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

FN · Answer

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

brady_brady · Answer

Hi,

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