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

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

FN — Sun, 11 Jun 2023 11:12:54 GMT

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.

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

brady_brady — Mon, 19 Apr 2021 16:00:29 GMT

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

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

FN — Mon, 19 Apr 2021 17:31:09 GMT

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