Consolidate several outputs in a single spreadsheet

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

CA+Payroll+Accrual+Report 12.2.20 .xlsx

Developer Tools

Accepted answers

Emil_Kos

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-summary-tables/m-p/353242/highlight/true#M64634

Good luck!

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

All comments

AngelosPachis

Hi @glombard ,

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

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

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-summary-tables/m-p/353242/highlight/true#M64634

Good luck!

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

glombard

Thank you for your help.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703