How to join datatable which has exactly the same column name

Dear all,

Good day.

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?



Can you try Merge DataTable activity?


1 Like

I think you dont mean “join”, but you want to “merge”.

1 Like


You can use Join Data Tables activity… you can scan this docs as below,


1 Like

Dear all,

Thanks for the suggestion.

ya i use the merge datatable activity and now able to combine to get one final datatable.

Thanks a lot

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