I’m reading from a datatable and attempting to filter out various results.
The first file is produced by reading a datatable & filtering where the Status column is populated. This works fine.
The issue is the second file - I’d like to produce a file where the status column is empty (the rest of the columns can be populated). This file can have 0 rows or many.
I do this at the moment by assigning dt2 = dt1.Select("[Status]=’’") then passing that to an output file. When the results offer one or more rows it works fine. When the file is empty, I receive the error 'The source contains no DataRows '.
I’ve tried to use an ‘if’ statement dt2.Rows.count() > 1 then either writing to a file or stepping over. I can only do this after the Assign has taken place. But the Assign is where the error seems to be thrown…