Filter Data Table Activity

[Manjuts90]

@ecarles Check the below link, it might be useful in ur case.

Deleting rows from a sheet after filtering

Thanks @MAHESH1 ! Got 2 queries regarding filtering a data table and writing filtered data into new sheet as you mentioned before. Suppose if the filtered data table contains no rows, I don’t want the new sheet to be created then. How do I ensure that the bot moves to the next item and does not stop ? How do I use a “less than ( < )” in a filter ? Say for e.g. in the code - dt1=(From p in dta.Select() where Convert.ToStringf(p.Item(“Column C”)).Equals(“Value”) Select p).ToArray.Copy…