Challenge in getting an associated values from around 800k records

Help Activities
, , , , ,
1

Hello guys,

I have a situation to take one unique ID number (UID) from Excel A and check if certain values are present in Column A or Column B of the Excel B associated to the UID (from Excel A). Problem is, Excel B has 800k + records… Where as i have 20k UID values in Excel A.

Each UID of Excel A would have around 500+ rows in Excel B. i know its tough through UiPath, but i wanted to do it here. How can i solution it? Any suggestions?

If the Column A or Column B of my UID is having my expected value, i will have to update a column as “yes” for that specific UID in Excel A. is it doable in UiPath?

2

Yes, I think so. My idea would be you do a For Each Row in Datatable A, using the UID filter Datatable B.
And then either use a Lookup Datatable or another For Each Row of Filtered Datatable to check for your expected value.

3

Please elaborate more with example. I will provide linq for the same