Ignoring "Excluded" rows

NRW

Hello,

 

I'm still trying to get over the JSL "hump," so forgive the fundamental question.

The issue:

- I have a sample table that contains data sets for three replicates with sample suffix a1, a2, and a3.

- At times, one of the replicates needs to be set to the "Excluded" state (example below is a2)

- I'm writing a batch script that will open a table and apply calculations only sets that were not excluded.

- However, I'm still not there with my attempt (shown below) since data from all three are still being considered.

- I feel like an "and" statement may be necessary to  identify non-excluded rows, then applying search for suffixes. 

 

Any input, would be most appreciative.

 

Thanks Neil

states = Current Data Table() << Get Row States();
	For( i = 1, i <= N Rows( states ), i++,
		rs = As Row State( states[i] ); 
		if (Excluded(rs)==0, 
		
			a1 = dt << Get Rows Where(Contains(:Sample,"a1"));
			a2 = dt << Get Rows Where(Contains(:Sample,"a2"));
			a3 = dt << Get Rows Where(Contains(:Sample,"a3"));		
		);	
		
	)

 

 

ih

It looks like you are iterating over the list of excluded rows but then doing the same analysis every time, which doesn't actually reference the list of excluded rows anywhere.  Here is one way that might solve your problem, which gets matching rows and excluded rows, and then just removes excluded rows from the list.

 

Names default to here(1);

//Make a sample dataset with some excluded rows
dt = Open("$Sample_data/iris.jmp");

excluded rows to set = [ 4, 9, 52 ];
dt << Select Rows( excluded rows to set );
dt << Exclude(1);

//Find all matching rows and load in associative array, useful for Remove From function later
species matches = associative array(dt << Get Rows Where(:Species == "setosa"));

//get excluded rows
excluded rows = dt << get excluded rows();

//remove excluded rows from the list of rows matching the species
Remove From (species matches, excluded rows);

//get the matching rows as a list
speciesmatches << get keys;