How to row index of a data table without for each loop

[kishore.shetty]

How do I get index of a row in data table when that rows column value is matched without using for each loop?

Thank you

[TimK (Tim Kok)]

inside a for each loop - if your value matches -

you can use:

DTVariable.Rows.IndexOf(row)

This will give you an integer variable

Think post was edited after my response by @KarthikByggari solution will work nicely

[fernando_zuluaga]

hi @TimK
try that

How can i get the row index?

Hi @sermuolo You can use this : [your DataTable variable].Rows.IndexOf(row) which [row] is defined as the row of [your DataTable variable] in [for each row ] activity .

Regards!

[AshwinS2 (Ashwin S)]

Hi @fernando_zuluaga

U can try with datarow array

Get Index Row from a DataRow, not a Datatable

Hi @Ionut_Istrate you transform DataTable into DataRow[] it’s an array of DataRows, if you want to access items in a dataRow[] you will use the same logic of accessing items in DataTable meaning YouDataRowArray(0)(0) will give you the first item of the first row. Regards, Reda Marzouk

Thanks
Ashwin S

[KarthikByggari]

Please use the following activity to get the row index -

Lookup Data Table

Regards,
Karthik Byggari