How Comparing Two excels and adding values to the existing sheet


@Dilli_Reddy

Welcome to the community

use a join activity …all the records would be mapped

cheers

1 Like

@Dilli_Reddy

Hi use this

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

Then use for each row in datatable for dt1

Assign
Currentrow(2).tostring=dictvalues(currentrow(0).tostring)

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.