hi . how can i copy data from row using linq. i’m comparing 2 id in two different excel . and if the the id in excel 1 find the id in excel 2 it will copy the value of specific column i used this code to compare two id and write default value in specific column If(IsNothing (MSMEDT.AsEnumerable.W…

Hi @ldiaz Try this approach [image] [image] [image] Refer the project DT_CompareAndUpdateColumnValues.zip (15.3 KB)

Linq help

kumar.varun2 (Varun Kumar) October 3, 2022, 4:05pm 4

Try this approach

Refer the project

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
Excel Automation 3 Something Else feedback	8	791	October 4, 2022
Linq query not working to copy values between two datatables Something Else datatable , excel , studio , linq	3	922	July 13, 2021
Compare two excel sheet and check the two column values are match or not Activities excel , activities , studio	5	796	September 25, 2022
Need LINQ For below datatable Studio excel , activities , studio , linq	6	244	November 24, 2023
How to get a cell value from an excel file with LINQ RPA Discussions coding , general	5	2298	October 24, 2022