can you please let me know how to delete a specific row based on certain condition.
I have gone thought some of the suggestions but not working out.
I have excel file like below.
I have to delete a row when the status = ‘Closed’ and the Closed_date >=30 (with current date) like below.
currently I am reading into a data table then for each row check for closed rows then closed date is more than 30 days or not, after that passing rowindex to Remove data row activity but getting error from Remove data row activity. Error is " [Collection was modified; enumeration operation might not execute]
Could you please help on this.
Thanks in Advance,