How Comparing Two excels and adding values to the existing sheet

Dilli_Reddy · August 31, 2023, 4:00pm

Anil_G · August 31, 2023, 4:07pm

Welcome to the community

use a join activity …all the records would be mapped

cheers

Shiva_Nikhil · August 31, 2023, 5:43pm

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

system · September 3, 2023, 5:43pm

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