Find row number in data table / (datatable) in Studio

[herman]

Hi,

I have been all over this forum, and just can’t seem to find how to find a row number in a data table.

Attached is a screen shot of the XAML file.

CustGroupDT (data table) has two columns:
Col 1 = CustGroupDropDown, containing the string values, and
col 2 is CustGroupSequence of INT32, containing a sequential number. Now whether I count the rows (if I’m looking for “Retailer”) or using col 2, is not a problem. The most efficient method would be appreciated.

How do I get the numeric row value of the “Retailer” value in the CustGroupDT data table?

[NIVED_NAMBIAR (NIVED N)]

Hi @herman

U mean u need to get rowindex if particular value in datatable ?

[herman]

Hi Nived,

Correct, I’m looking for the row number of a specific value/string in the DT.

[Alesia6666 (Alexandra Dzihovska)]

Try this Lookup Data Table

[NIVED_NAMBIAR (NIVED N)]

Hi @herman

Did u tried with lookup datatable activitiy ?

[herman]

Apologies for the late reply - I have utilised Lookup Data Table activity, but the write line on RowIndex gives me a -1. Assuming the value I’m looking for is not in the DT, although the string conversion of the DT does show it

[herman]

I have put a Watch on the DT, and the value I’m looking for is in there.

Screenshot 1 shows the CustGroupDT watch,
while screenshot 2 shows the DataTable and LookupValue
screenshot 3 shows the write line for RowIndex output as -1

Any ideas why I get a -1 when write line Test

[NIVED_NAMBIAR (NIVED N)]

Hi @herman

I think the value u are looking is under first column so column index should be 0 instead of one in lookupdatatable propertypanel

Hope it works

Regards

Nived N

Happy Automation

[herman]

Thanks, I kept using Column 1 - solved it!