topic Re: interaction between two data tables in Discussions

interaction between two data tables

CumulativeMean2 — Mon, 19 Aug 2024 07:47:48 GMT

i have two data tables, data table A is the source file, data table B is the subset of A and went through table -> split in JMP.

Both data table A & B consist of unique number under column name called UNIQUE. Can i interactively move from one row to next row in data table B & get the corresponding row in data table A highlighted or selected, meaning data table A & B linked together using unique column named UNIQUE?

This is JMP17.

Re: interaction between two data tables

jthi — Mon, 19 Aug 2024 08:22:34 GMT

Try if virtual join would work for you. If I remember correctly it does require both of the tables to be saved and that there is unique "ID" (it can only appear once in the column) in one of them

Virtually Join Data Tables (jmp.com)

Re: interaction between two data tables

Byron_JMP — Mon, 19 Aug 2024 17:38:21 GMT

When you make the subset, make sure you have this option selected:

Then the child table will be connected to the parent table. Changes in the child occur also in the parent.

Note: Once the two tables are saved and reopened, the link will be lost.

if you are interested in remaking the same subset frequently, make sure you have this option checked to save the subset script to the parent table.

Re: interaction between two data tables

hogi — Mon, 19 Aug 2024 20:28:38 GMT

Most probably Table / Split will cut the link between the tables.

To establish a link, use Virtual Join
https://www.jmp.com/support/help/en/18.0/#page/jmp/link-data-tables-with-virtual-join-properties.shtml
and activate either dispatch or accept for the row state Select:

Re: interaction between two data tables

CumulativeMean2 — Fri, 23 Aug 2024 06:24:30 GMT

Virtual join works by doing these steps for my case. it does not solve 100% of my issue.

1. data table A with column name "UNIQUE". Some of the rows are with same content under "UNIQUE", meaning UNIQUE is not unique in data table A. Save data table A.

2. Tables -> split as data table B with UNIQUE as column & tick "Save Scripts to Source table". Set UNIQUE as link ID. Save data table B.

3. Set "UNIQUE" as link reference and ticked "Select" under link reference properties in data table A.

4. when i select the content under UNIQUE in data table A, the UNIQUE in data table B will be highlighted.

what i would like is the UNIQUE in data table A is highlighted when i move row to row in UNIQUE in data table B.

Re: interaction between two data tables

hogi — Fri, 23 Aug 2024 08:04:10 GMT

Then switch form "Dispatch" to "Accept" mode.

Re: interaction between two data tables

CumulativeMean2 — Fri, 23 Aug 2024 08:29:39 GMT

it works by changing "row States Synchronization with Referenced Table" in link reference of data table A from Dispatch to Accept.