How to delete row by index name

[jai_kumar2 (jai kumar)]

hi

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

[Yoichi]

Hi,

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

Regards,

[Gangadhar_Athili]

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

[postwick (Paul Ostwick)]

You have the columns set wrong:

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

[jai_kumar2 (jai kumar)]

Thank you , its working

[jai_kumar2 (jai kumar)]

Thank you all, for a Reply