Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Combining two separate data streams to make 1 excel workbook with 2 tabs

NRD
8 - Asteroid

Hi All,

 

I have a scenario where I have two different data streams and I need to send both of these to excel as one workbook with two different sheets. How would I go about doing that?

2 REPLIES 2
skeen503979
8 - Asteroid

Hi there, @NRD.

 

The answer to your question is in how you configure the Output Data tool.  Simply connect each data set to their own Output Data tool and give the file the same name.  *Note* The file name must be the same (so your tabs are built into the same one file).  You can create separate tabs within your new file by giving each tab a unique name when the pop-up screen asks which sheet you want to name it.

Enjoy!

 

skeen503979_1-1617720171332.png

 

 

 

skeen503979_0-1617719897195.png

 

 

 

randreag
11 - Bolide

hi @NRD 

 

You can load both data streams, then use a formula o the filename to identify each one of them .After that you can use a union tool and send it to an output tool where you can use the option take file name from field and choose the field you created to identify each sheet.

 

aruiz-itp_0-1617720397234.png

 

 

If the columns are diferent  you would need to separate the output for each sheet , but using a block until done to write one and then the other

 

If you have some sample files, I can show you

 

 

Labels