Compare two datatables and copy sum of column from one datatable to another

Help Studio
, ,
1

Hi ,

I have two datatables Dt1 and Dt2. I want to compare Name and location in both these datatables and if it matches, then I want to copy the sum of column “cost” from Dt2 to a column “price” in Dt1.

Since no. of rows in Dt are>10k, please suggest a way through linq

Thanks!

2

https://forum.uipath.com/search?q=compare%20datatables

3

LINQ is not faster. It’s a myth. LINQ still loops through the data, it’s just hidden behind an abstraction layer.

4

I have tried searching the forum but not found a similar problem resolved.