7785_en-US

liliconcom

Saving Row Statings When Joining Tables<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Is it possible to save the row states when joining a table to another?  For example, if I have some data excluded or marked as a different color and then join that table I lose those row states and need to repeat those actions.  This is something we do frequently and it would be a big time saver if those row states would carry over.

Thanks,

Michael

Re: Saving Row Statings When Joining Tables

Thank you, Jeff that helps alot.  I was able to view the video in the response sent to my email, however it's not showing up in the forum thread.  I can see that video being useful for other people in the future.

Thanks again,

Mike

Re: Saving Row Statings When Joining Tables

As you've discovered active row states are not carried through a join operation as there's a potential conflict if matching rows in the two data tables both had row states assigned.

Instead you can store your row states in a row state column that will be available in the joined data table.

Here's a video that explains row state columns.

https://www.youtube.com/watch?v=MuiAnkZBS0c

-Jeff