How Comparing Two excels and adding values to the existing sheet


Welcome to the community

use a join activity …all the records would be mapped


1 Like


Hi use this

Dictvalues=Datatable.AsEnumerable.todictionary(function(×) ×(0).tostring,function(r) r(1).tostring

Then use for each row in datatable for dt1


Outside of for each use write range workbook for datatable1

Hope this helps cheers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.