Subscribe Bookmark RSS Feed

Row attributes lost when Joining data tables

ylee

Occasional Contributor

Joined:

Nov 16, 2016

Hello,

 

I have a main data table (dt1) where I'd like to Join it with another data table (dt2).

 

The main data table (dt1) contains some row attributes where certain rows are Excluded, certain rows are marked with specific Markers and Colours.

 

When both data tables are joined, producing a new data table (dt3), this new data table no longer hold the row attributes mentioned above.

 

Does anyone know how to join dt1 and dt2 while keeping the row attributes in dt1 intact?  I would use this in JSL too.

 

Thank you.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Solution

A Row State Column is used to store row states and will be preserved across table operation.

 

UG_ColumnInfo_2.png

 

Create a new column and give it a Row State Data Type.

JMPScreenSnapz075.png

Then you can click on the star in the columns panel of the data table and choose "Copy from Row States" to capture the current row states.

JMPScreenSnapz076.png

 

-Jeff
2 REPLIES
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Solution

A Row State Column is used to store row states and will be preserved across table operation.

 

UG_ColumnInfo_2.png

 

Create a new column and give it a Row State Data Type.

JMPScreenSnapz075.png

Then you can click on the star in the columns panel of the data table and choose "Copy from Row States" to capture the current row states.

JMPScreenSnapz076.png

 

-Jeff
ylee

Occasional Contributor

Joined:

Nov 16, 2016

Thanks Jeff, it works!