Hi Team, I have 2 excels excel1 Col1,Col2 A 4 B 5 C 6 Excel2 Col1,Col2 M 6 N 7 B 8 if Col1 of excel1 matches Col1 of excel2 add Col2 eg B matches in both then my answer shoulld be 8+5 new datable will be col1,col2 B 13 regards, supriya

Linq query to compare two datatatables and sum column values of matching row

Jobin_Joy (Jobin Joy) December 9, 2021, 7:08am 2

Kindly refer the below solution,

Hope this will be helpful. Thank you.

Topic		Replies	Views
Comparing values and adding data to one data table Studio studio , question , project_panel	14	574	July 19, 2023
Compare two different data tables through linq Studio uiautomation	9	2341	January 19, 2022
Linq query for comparing 2 datatables Activities excel , activities , question	8	945	July 6, 2023
Linq query to compare two datatable and return values Studio activities , question	5	333	October 10, 2023
LINQ Query for matching row from another Excel column and update the Result Community datatable , excel , activities , studio , question , community	11	1615	January 16, 2023