Combining Multiple Output files into one output with Different tabs

Question

Hi,

I am beginger in Alteryx, Can anyone help me in combining multiple output files into one output file with different tabs in Alteryx.

Note - All the the output file have different column & data. Hence we need to combine all the output file into one with different tabs. Sample file attached for reference.

final Output.xlsx

Output 2.xlsx

Output 3.xlsx

Output 1.xlsx

binu_acs · Answer

@Srawat What is your requirement?

Srawat · Answer

hi @JagdeeshN

Parallel block until done tool is working for 3 input only if we need more than 3 output in one file then it will not accepting more than 3 output. Could you please advise if we can get more then 3 output in one file.

Thanks,

Rajeev

fmvizcaino · Answer

Hi @Vicky92 ,

The problem you might me having is related to the excel trying to open all files at the same time and it shows the same error as if you leave the excel file open.

Since you have 3 different file structures and also all of them are not connected, we need to find a way of ordering them and that can be achieve by using a combination of sample tool + append tool

1. Block until done: ordering processes, output anchor 2 will only start sending data after anchor 1 finishes everything there

2. Sample tool: being used to select only one row

3. Append tool: It is a blocking tool and that means the tool will only output data from the T anchor after receive all the data from the S anchor

There is also a crew macro from the great @MarqueeCrew that can simplify this whole process.

Check this out: https://www.youtube.com/watch?v=g4lN92sXZlY

http://www.chaosreignswithin.com/p/macros.html

Best,

Fernando Vizcaino

2021-07-21 Combining Multiple Output files into one output with Different tabs.yxmd