Getting Row index value from data table

Hi All,

I am comparing the two excel sheets using filter data table activity.

Now , i want to find the row index value of the excel sheet after filtering data.

Can any one help me to solve this issue?

Hi @ChaitraMN


Ashwin S

Hi @ChaitraMN Use dt.rows.indexof(Yourdatarow)

how to get a particular value like

in this we only want to check the values of PT and TT is NTT and 102

1.Read the excel sheet and store it in datatable(Eg:DtTest)
2.Use select query to get the value and assign to datarow"[PT]=‘NTT’ AND [TT]=‘102’ ")
3.Use for each row to get the value