How to join datatable which has exactly the same column name

Help Activities
1

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?

THANK

2

Hi,

Can you try Merge DataTable activity?

Regards,

1 Like
3

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

1 Like
4

@irene0227,

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

Cheers,
Pankaj

1 Like
5

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

6

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