Unhide/Unexclude rows without changing other row states using JSL
Dec 29, 2017 7:49 AM
| Last Modified: Jan 4, 2018 5:27 AM(3449 views)
How can you clear a specific row state (ex: excluded) without modifying any other states (ex: color)?
Today I get the table's row states, convert the applicable row states to binary, clear the appropriate digits, convert it back to decimal and set the row state again using As row state().
The reverse, excluding a row leaving other sates intact is pretty straight forward:
//Open table and set a row to selected/hidden
Names default to here( 1);
dt = Open( "$Sample_data/iris.jmp" );
Row state(3) = As row state( 5 );
//Exclude the row without changing other states of the row
Row state(3) = Combine States(Row state(3), Excluded State(1));