Alteryx Designer Desktop Discussions

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

Macro output to one excel in different sheets

DenisZ
11 - Bolide

Hi, 

 

I have a macro output with 4 outputs (screenshot below). I would like however, all these to connect and show in one excel sheet. Any tips?

 

Br, 

 

Denis

 

DenisZ_0-1679648237641.png

 

1 REPLY 1
BS_THE_ANALYST
14 - Magnetar

By "connect", you should try to either the Union Tool to stack the data vertically. Or you can use the Join or Join Multiple tool, to combine the data streams. The join will act similar to a vlookup in Excel. 

BS_THE_ANALYST_0-1679649774416.png


Hopefully that makes sense. It depends on how you want to combine the data.

 

After you've combined the data in your desired way, you just need to use the Output Tool and configure it to a .xslx file or .csv:

BS_THE_ANALYST_1-1679649916922.png


Thanks,
BS

 

 

Labels