I have two datatables, both with the same columns. dt1 will have 10-20 rows that are from an older file. These rows have to be compared to dt2, which has 300-500 rows. How do I use linq to compare the rows from dt1 to dt2 and if the columns shown below all match, update the entire row in dt1 with w…

Thanks all. I was not able to utilize some of the above suggestions and get them to work. I ended up using a couple of nested for each row in DT activities and looped through dt2 with the current row from dt 1 looking for a match and then adding it to an additional table. I don’t think it’s the quic…

Compare 2 datatables and update Rows if 4 columns match

Help Studio

adiijaiin (Aditya Jain) September 11, 2023, 1:43pm 2

hi @mbuehler

You can refer the below article and get the details:

Thanks

Topic		Replies	Views
Compare 2 datatables with the help of linq and update one datatable with rest to other table Studio studio , question , project_panel	6	1066	April 14, 2023
Compare two datatable based on common column if match found then update values from other datatable to specific column in first datatable values Activities datatable , excel , activities , studio , linq , join-data-tables , linq-query	13	12646	February 23, 2023
Update Column By Comparing two datatables using Linq Query? Help datatable , excel , uiautomation , studio	8	4487	April 1, 2020
Linq to filter and update datatable Activities uiautomation	3	343	August 18, 2023
COMPARE TWO DATATABLES AND GET NEW DATATABLES WITHOUT USING LOOPS! Help orchestrator , activities , studio	8	5922	April 30, 2022

Compare 2 datatables and update Rows if 4 columns match

Related topics