I have one excel file which has the same column name but is in different sheet.
Excel name: DO monitoring sheet
Sheet name: Apr & May
Datable: Apr (DT1), May (DT2)
i use read range activity, to get DT1 (Apr) , DT2 (May), use join datatable , and write range (CombineDT)
But it wont show as using the same header, it will show Delivery Date_1
Can anyone help on this?