topic Re: Row attributes lost when Joining data tables in Discussions

Row attributes lost when Joining data tables

ylee — Tue, 21 Feb 2017 08:04:12 GMT

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.

Re: Row attributes lost when Joining data tables

Jeff_Perkinson — Tue, 21 Feb 2017 14:31:50 GMT

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

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

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.

Re: Row attributes lost when Joining data tables

ylee — Wed, 22 Feb 2017 02:08:19 GMT

Thanks Jeff, it works!

Re: Row attributes lost when Joining data tables

TomHerman — Sat, 16 Feb 2019 15:19:00 GMT

I'm a relatively new user that had the same question.

While it's true that the Row State Column was preserved after a I did a Table Join, the _actual_ Row States were cleared.

How can I make the _actual_ RowState of the new, joined table automatically update to reflect the information contained in the Row State Column?

(Note that I'm working in the interactive GUI, not JSL, and want to keep using only GUI, for now.)

Re: Row attributes lost when Joining data tables

TomHerman — Mon, 31 Dec 2018 22:04:32 GMT

The attached imiage file in my previous post is a screenshot of my joined data table, showing how the actual Row State didnt update after the table join.

I fumbled, but couldnt get the screenshot to display inline with the text of my post.

Re: Row attributes lost when Joining data tables

txnelson — Mon, 31 Dec 2018 22:37:09 GMT

You apparently followed Jeff's example from above and generated a column with the Modeling Type of "Row State" and then right clicked on the red star for the new column and selected "Save from Row States". Once you complete the join of your tables, you can then go to the column that you saved the row states to, and this time after to right click on the red star, select "Copy to Row States".

Re: Row attributes lost when Joining data tables

TomHerman — Tue, 01 Jan 2019 00:15:06 GMT

Thanks!