Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Consolidate several outputs in a single spreadsheet

glombard
7 - Meteor

Hi,

 

I need your help, please on the following request.

 

I have a workflow that creates the output in an excel file in 3 different tabs. The user wants to get the 3 tabs in a single tab as shown on the attached file.

 

Could you please help me with this request?

 

Regards,

Gilberto

3 REPLIES 3
AngelosPachis
16 - Nebula

Hi @glombard ,

 

You can bring those 3 sheets together and stack the on top of each other with a union tool :

 

AngelosPachis_0-1607532870325.png

 

You can find more on how to configure the tool in the following link:

 

https://help.alteryx.com/current/designer/union-tool

 

Hope that helps.

 

Cheers,

 

Angelos

 

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

I believe you need to use reporting tool. As I currently don't have access to Alteryx I am not able to prepare a workflow for you. Alternatively I found a post that might help you with your task:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reporting-how-to-combine-multiple-summ...

 

Good luck! 

 

Please mark my post as an answer if this is helpful.

glombard
7 - Meteor

Thank you for your help.

Labels
Top Solution Authors