Deleting rows from a sheet after filtering

Help
26

Thanks @MAHESH1 ! Got 2 queries regarding filtering a data table and writing filtered data into new sheet as you mentioned before.

  1. 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 ?

  2. 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.CopyToDataTable

Here if “Value” = 100 , I want to filter Column C by rows that are less than 100.

How can we do this ?

Thanks!