I have 2 excel sheets which has different headers. in that i have to compare 1 column in each of the sheets. if any data matched i have to get the value from different column in the 2nd excel sheets and store it to the1st excel sheet.
Have you tried using Join Datatables Activity ? Inner Join should be able to get your expected output, However, after the Join Activity you would need to use DefaultView.ToTable() method and preserve only the columns you require. Then perform the change of the column name if necessary.