delete rows with same values except...

[#1]

Hello to you, I have this table and I want to delete all duplicated rows based on "entity" and "layer" column value with one exception - I want that rows that have the value "set process allowed to" in "layer" column, will stay and not delete the duplications. Would like your help with it:

 

[#2]

After you select all of the duplicate rows, then all you have to do is to find the rows you don't want to be selected and then unselect them.

Here is an example

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

dt << select duplicate rows( Match( :sex, :height ) );

// Find the rows that should not be selected
theRows = dt << get rows where( :weight == 92 );

// Unselect those rows
For( i = 1, i <= N Rows( theRows ), i++,
	Row State( theRows[i] ) = Selected State( 0 )
);

[#3]

Thank you very much

[#4]

In addition to @txnelson's script, you should also learn how to use JMP's interactive commands for row operations. Please see this help about selecting rows and this help about finding rows.