Hi, I have a 2 datatable consider dt1 and dt2,I need to compare the column1 of dt1 with column1 of dt2 and update the column2 of dt1 with column2 of dt2.I am able to update the value but in dt2 there is a 2 matching value,so I want to take the very first match and update . Please help me for linq …

Hi @yashashwini2322 => Read Range Workbook Output → DT1 => Read Range Workbook Output → DT2 => Use the below code in Invoke Code: Dim dt2Lookup As Dictionary(Of String, Double) = dt2.AsEnumerable() _ .GroupBy(Function(row) row.Field(Of String)("column1")) _ .ToDictionary(Function(g) g.…

Compare 2 datatble and update the very first matching value

Help Studio

yashashwini2322 (Yash) April 12, 2025, 2:20pm 5

Thank you,it working fine

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
Obtain value from second datatable based on first datatable Studio datatable , excel , studio , question , activities_panel , linq , data-comparison	15	1280	October 12, 2022
Values match of two column of data table Studio studio , question , activities_panel	7	916	September 25, 2021
Compare two different data tables through linq Studio uiautomation	9	2748	January 19, 2022
How to compare two data table row by row, column by column and cell by cell and update the cell value if it is not matched.Give the solution using invoke code Help activities , question	6	975	January 7, 2020
How to match row value using linq and update status column as matched or not matched Studio studio , question , activities_panel	12	777	October 13, 2023

Compare 2 datatble and update the very first matching value

Related topics