Find the row of particular word and delete all above rows

Help Studio
1

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

2

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

Regards,
Arivu

3

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

4

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
DataTable.Select().Skip(rowIndex).CopyToDataTable()

Regards,
Arivu

5

Thank you

6

Does this query delete rows of that keyword also?

7

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