Choose Language Hide Translation Bar
Highlighted
ZZHAO
Level I

How to Join tables

Hello,

 

I have 2 JMP tables I want to join them. In each tables, I have exclueded and hided a few rows. When I did join, the excluded/hided rows were showing in the joined table, which is something I don't want. Does anyone know how to join 2 tables and do not include the excluded rows?

 

Thank you so much in advance.

 

Zhengxin

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: How to Join tables

The way to do this is to subset the data tables prior to joining them, first selecting all of the rows that have not been hidden and/or excluded. Then join the subsetted tables.
Jim

View solution in original post

3 REPLIES 3
Highlighted
txnelson
Super User

Re: How to Join tables

The way to do this is to subset the data tables prior to joining them, first selecting all of the rows that have not been hidden and/or excluded. Then join the subsetted tables.
Jim

View solution in original post

Highlighted
ZZHAO
Level I

Re: How to Join tables

Thank you for the responce. Yes, this work-around works. However, it will just make the header name longer after join due to subset is added to filename of subsetted tables

Highlighted
txnelson
Super User

Re: How to Join tables

in your subset request, you can set the name of the new output data table
Jim
Article Labels

    There are no labels assigned to this post.