Combine multiple tab with different column

[SH_94]

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

[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]

@SH_94 

Use the Formula tool to replace the Sheet Names in the Filename.

Want to replace with A, B, C.

Formula tool:

Output:

Now you need to read the sheets based on your requirement how to combine the sheets as you might have a business logic how to combine the sheets.

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

[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

[ShankerV]

Hi @SH_94 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

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

[ShankerV]

Hi @SH_94 

As you are new to macro, explaining how to make use of my solution in your system.

Download both the files attached, 

1. Combine multiple tab with different column (Alteryx workflow)

2. Community help (Macro)

In the alteryx workflow, in the Input tool change your file location of SAP file stored.

Then Run the workflow, to get the desired output.

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