Combine multiple tab with different column

Hi community,

I have excel file that have a lot of sheet/tab with different name of the column for each sheet as per attached file. May i know if there is anyway to combine the list of sheet together using macro as i quite new to the macro?

Tab A

Tab B

Many thanks in advance

SAP Generated file.xlsx

Common Use Cases

Accepted answers

All comments

ShankerV

Hi @SH_94

Please use the input tool to read only the sheet names.

Then read all the sheet names separately to so that you can avoid macro and do in 2 tools.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

SH_94

Hi @ShankerV ,

Thank you for the prompt response.

Currently i at this stage as per screenshot below. May i know how to proceed after the input data tool as the result is show as per screenshot below

Result window view

Thank you

ShankerV

@SH_94

I am trying to build a solution however struck with the logic to combine the sheets.

As all 3 sheets has different columns (schema), could you please let me know how you like to combine.

Please share the expected output.

Many thanks

Shanker V

ShankerV

Hi @SH_94

Finally use the Dynamic input tool to read the sheets in the same excel sheet based on the business logic to combine the sheets with different schema.

Many thanks

Shanker V

SH_94

Hi @ShankerV ,

Currently i am planning to have output as below '

Expected output 1 ( combine all the details together disregard the different of schema in the format below)

Expected Output 2 ( combine in the format below )

Is it double for both output?

Thanks in advance

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703