I have a data table with following data.
I need to delete all the records of Jan 21 after reading the first Jan 21 record. So after the first iteration of for each row I have to filter out all Jan 21 records and remove from the data table within the for loop.
Using filter activity and then using Remove Data Row within the filtered data table throws below error.
For Each Row: Collection was modified; enumeration operation might not execute.
Using Select method also throws error as we need to pass the column value in ’ ’ single quote and the data itself contains ’ single quote.
Can anyone help how to delete the rows within the for loop after filtering ?