How to delete row by index name


iam trying to delete row by indexName/“string” by using filter data table activity

i want to delete two row contains “Columno” and “Line item Details” and populate it to sheet 1
but in result those two rows are not deleted


Can you try to modify the following operator from AND to OR?



1 Like

DT=DT.Asenumerable.Where(Function(r) Not(r(0).Tostring.Contains(“Column0”) Orelse r(0).Tostring.Contains(“Line item Details”))).Copytodatable

You have the columns set wrong:


Change those to the actual column names (inside double quotes) and set it to OR not AND.

Thank you , its working

Thank you all, for a Reply

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.