I have a scenario where I need to find row matches in two datatables where a certain value is found in both rows. Then I need to extract the row index of each match to use as an anchor for a selector. Would it be as easy as using the DataTable.Rows.Contains method to check if the table already cont…

I ended up using a for each loop to add specific data from a certain column in the first datatable to a collection (list). Then I used a for each loop to iterate through the list and use the lookup datatable activity to lookup the second datatable, and where there is a match I assigned the row inde…

Compare two datatables and find row index of matching data

Help Studio

loveleet_Saini (loveleet Saini) November 22, 2022, 11:24am 3

Hi @b.forbes

You can also look at:
Get column index and row index for specific values - Help - UiPath Community Forum

Thanks & Regards
Loveleet Saini

1 Like

Topic		Replies	Views
Easier way to find matching rows in a datatable while retaining the original row index? Something Else feedback	1	742	July 1, 2023
Lookup Partial Value and find target row index Studio	9	1606	July 6, 2022
Query for comparing two datatables Studio	6	928	August 5, 2021
Compare two datatables and return row index using LINQ Studio datatable , robot , question , linq	1	986	January 3, 2023
How to row index of a data table without for each loop Academy Feedback excel , activities , question	5	14773	December 6, 2019

Most Active Users - Yesterday
mkankatala
Anil_G
pravallikapaluri
Yomi_Oluwadara
Yoichi
postwick
Parvathy
vrdabberu
DimitriLYR
lrtetala
More details...

Compare two datatables and find row index of matching data

Related Topics