218037_en-US

liliconcom

Invalid Row Error

I have a script section that finds errors in the data set. I want to find these errors and color the cells then create a subset of all rows with errors that group into the first subset. I got it working for most of the error types, but when I used the same theory for the two conditions that go into the the second subset it gives an alert that says "Invalid Row". When I run the sections manually they work, but when I run the script all the way through the error stops the run. I can't figure out why one section works and the other doesn't.

 

Here's the script for the expression cause the problem. The section titles "Find and highlight data entry errors" works, but the one titled "Find and highlight missing failure mode or no explanation when failure mode is Other" does not work.

 

find errors = Expr(

//Find and report data entry errors

 //Create subset of only select date range
 DS<<SELECT where="">");
 selected = As List(DO<<GET selected="" rows="">");
 DO<</GET></SELECT><SELECT where=""></SELECT>

 

 

Re: Invalid Row Error

There is a good chance that you are specifying

<< get selected rows

no rows are being returned.  Then when you attempt an operation, it comes back with Invalid Row

Re: Invalid Row Error

@txnelson I thought that might be the case, but I know there are cases that it should be finding in the data set I was using to test/develop the script. I tried a simplified test case where with one selection that would find things and one that intentionally would not. The one that didn't select any rows didn't stall the script and appropriatly just didn't highlight anything.

Re: Invalid Row ErrorCan you attach a sample data table?Re: Invalid Row Error

I attached a sample table. It's the same structure as the one I'm dealing with, but with generic values replacing the data columns not related to this question.

Re: Invalid Row Error

Using these values, I found no errors when running your code

sdate = "01/01/2019";
edate = "02/01/2019";
summarize(ds, all sealers = by(:sealer number)) ;
summarize(ds, all pouches = by(:Pouch CPN)) ;