topic Re: select where conditions not met in Discussions

select where conditions not met

LasersAreCool — Sat, 10 Jun 2023 23:42:09 GMT

I have a script running everyday to determine what parts have failed. We had a day where none of the parts failed and since my select where condition was not ("Fail") it grabbed all the passing parts and output them to the next table. How do I write it so that if no parts fail, the next tables should be blank?

Example:

Data Table ("Parts")<< select where (:PassOrFail == "Fail");
Data Table ("Parts")<< subset (Output Table ("Fails", selected rows (1),selected columns(0)));

Since there were no "Fail" in my PassOrFail Column, the output table "Fails" was just a replica of the original table "Parts"

Re: select where conditions not met

txnelson — Tue, 04 Jan 2022 18:27:54 GMT

Data Table ("Parts")<< select where (:PassOrFail == "Fail");
If( N Rows( Data Table("Parts") << get selected rows ) > 0,
     Data Table ("Parts")<< subset (Output Table ("Fails", selected rows (1),selected columns(0)));
);

Re: select where conditions not met

pmroz — Tue, 04 Jan 2022 19:22:05 GMT

Use get rows where instead of select where:

fail_rows = Data Table( "Parts" ) << get rows where( :PassOrFail == "Fail" );

if (nrows(fail_rows) > 0,
	Data Table( "Parts" ) << subset(rows(fail_rows), selected columns( 0 ),
		Output Table( "Fails")
	);
);