Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Multiple Outputs - One Excel File

harithad1
7 - Meteor

Hi,

 

Need your inputs on how to bring all the outputs in workflow into the same excel worksheet in different tabs. I heard about BUD tool, but in this workflow, i couldn't figure out where to place it.

 

 

1 REPLY 1
KGT
12 - Quasar

In order to use BUD, you'll need a point that all the extracts go through. You can do that by unioning dummy records etc between streams and then use BUD to control where data is, but that's not the way I would go about this.

 

I would work out some sort of order and which outputs could be output at the same time (to different sheets via the output tool) based on similar metadata. You can also create the data in a way that has the same metadata (columns F1, F2, F3 etc) with the headers in the first row and selecting to skip fieldnames on output. This all takes advantage of the option at the bottom of the output tool to "Take File/Table name from Field".

 

This is a bit of a different task, and you may find that re-organising the workflow makes it easier to output several times to the same file.

 

Labels
Top Solution Authors