Need the row index of a given value if there are multiple intense of it!

[Suhas_M (Suhas Mariyappa)]

Hi All,

I need the row index of a given value if there are multiple intense of it. I don’t want to change my original structure of the data.

for example 4900030673 is repeated twice So, I need the output as {5,11}. We can accomplish this in a For each loop activity. Appreciate any other suggestion

Lookup data table activity gives the output of first occurrence. However I need row index of all occurrences!!

Thanks in advance.
Suhas

[THIRU_NANI (NaNi)]

Hey!

Have a view on this thread…

This could be help you…

How to find a duplicate number in excel

Hi Friends, I have an excel with a column named Amount. I need to browse to that excel and find the amount value which i received from a different source in this excel and mark that row as yellow color.Currently it is working. However for a scenario belwo it doesnot. The received Amount is -123.45 The Amount present in the excel in row 5 is 123.45 The Amount Present in the excel in row 10 is -123.45 therefore according to my current code, the BOT verfies the record and says there is a dupli…

Regards,
NaNi

[Gangadhar_Athili]

DT.AsEnumerable.GroupBy(Function(r) r(0).ToString).Where(Function(g) g.Count>1).Select(Function(g) g.Select(Function(r) DT.Rows.IndexOf(r))).Toarray

[Veera_Raj (Veeraraj Sethuraman)]

please use lookup table by particular input value and its output is rowindex and cell value
you can easily get resolved

How to Lookup Data Table in UiPath - Full tutorial

[postwick (Paul Ostwick)]

@Suhas_M

We can accomplish this in a For each loop activity. Appreciate any other suggestion

Why do you need other suggestions? Just do it with a For Each. If you are thinking that For Each is slow, that’s a myth. Any method of doing this will require looping. Some methods, like LINQ, simply hide the looping from you but it’s still looping.