Find the row of particular word and delete all above rows

I have to find the row of “Entry code” keyword and wherever this row found.Delete all above rows

Hi @Tabbu ,
use below query to delete rows based on the keyword"ColumnName <> 'Key'").CopyToDataTable()


I dont want to delete that row.I want to delete above rows of that keyword row

Hi @Tabbu,

Use for each datatable activity to loop the data
If the keyword matched you can get the row index. and break the loop and use below query


Thank you

Does this query delete rows of that keyword also?

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