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