topic Re: Analysis between multiple tables in Discussions

Analysis between multiple tables

avolp — Tue, 15 Aug 2017 13:08:27 GMT

Hello,

I'm relatively new to JMP so was wondering if there are two tables with an identical column in each (Col A from Table 1 == Col A from Table 2), is there a way to do analysis between Col B from T1 and Col B from T2 without concatenating them?

Thanks

Re: Analysis between multiple tables

Daniel_Valente — Tue, 15 Aug 2017 15:06:20 GMT

Looks like a virtual join will do what you want here, assuming I am understanding the question correctly.

If Col A is an ID, which can link tables A and B, right click on the the Col A column in Table A and check "Link ID" (must be unique).

In Table B right click on the Col A column and navigate to link reference and then select the path of Table A.

A small gold key will show up in Table A:Col A, indicating that it is a Link ID and two keys will show up in Table B:Col A, indicating that it is a link reference.

Now in Table B you can execute an analysis like Fit Y by X and be able to analyze Col B in Table B and Col B in Table A without concatinating them.

Here is the resulting analysis. Col B in Table B is on the X axis and Col B of Table A is on the Y, linked together by the Col A IDs. There is a chance that this is not what you mean, too. If you simply want to apply the same analysis in Table B as you did in Table A you can save the script of a platfrom to the data table (platform little red triangle -> save script -> to data table..) and then copy and paste it to Table B. Then when you click the play button in Table B the same analysis will be run (since you have the same column names).

Re: Analysis between multiple tables

Chris_Kirchberg — Tue, 15 Aug 2017 16:26:04 GMT

Hi Avolp,
Yes, you can. In JMP 13 there is a feature called virtual joins that will allow this. Here is a link to learn more about virtual joins.
https://www.jmp.com/support/help/13/Virtually_Join_Data_Tables.shtml
Best,
Chris

Re: Analysis between multiple tables

avolp — Tue, 15 Aug 2017 16:45:38 GMT

Yes this is what I meant. thank you