How Comparing Two excels and adding values to the existing sheet

[Dilli_Reddy (Candy Reddy)]

[Anil_G (Anil Gorthi)]

@Dilli_Reddy

Welcome to the community

use a join activity …all the records would be mapped

cheers

[Shiva_Nikhil]

@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