Multiple input files into a single output file?

[jaypee1217]

I have an input file that goes through my workflow and spits out a final output file with 1 sheet.  I want to then insert my original input file as a 2nd sheet in the final output file.

[caltang]

I had encountered this issue and raise a Support ticket because in my mind, the Block Until Done (BUD) tool isn't functioning as it should in our case. 

Alteryx Support recommended me to put a delay before the output - and introduced some CReW macros from the marketplace as well as a solution. 

In any case, I had a discussion here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Saving-Multiple-Outputs-to-the...

In that discussion, there three potential solutions for you. But if you are on v2023.1, I highly recommend using Control Containers. That will be much better than BUD for now. 

If you are not v2023.1, you can consider my method by combining the data together and then split them. But the downside is that the data types are no longer preserved and are all forced to be strings.

[haraldharders]

@caltang . Thank you very much! Unfortunately, we are still at 2021.4. Let's see when we'll be allowed to install 2023.1.

So far, I will help myself with block until done and additional delays (while I had already issues with 10 s delay).

Unfortunately, having everything in strings is not an option.

Thank you again!