Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Getiing all the Outputs in 1 Excel Sheet

iamviraj13
8 - Asteroid

Hey Designers,

I know how to export output in Excel but I need help in getting all the outputs in just one excel sheet. The attached workflow has 6 summarize functions and those are the outputs I need to export in 1 sheet.

Capture.PNG

 

I have exported the tables manually. The example is for reference to how I want the outputs to be.

Capture.PNG

 

Any help would be appreciated. Thanks in advance.

11 REPLIES 11
RobertOdera
13 - Pulsar

Hi, @iamviraj13 

 

Hmm, what your asking likely means a solution with mapping outside of the Reporting Tools constraints.

 

You might deploy @rupali_bhise  idea (likely with Hold Until Done so that the write outputs don't run into each other and fail).

 

OR using the current solution you could run file1 sheet 1 flow, file 2 sheet 1 flow, and then a third flow to combine the files into one file with two tabs.

 

Cheers!

RobertOdera
13 - Pulsar

Hi @iamviraj13 

I reflected more on your ask.

I will create a new sample file similar to yours (so that you can use it and so that I can share with others without missappropriating your sample).

I will build a flows to handle both your original and current scenario+

Watch out for it this week!

Cheers!

Labels
Top Solution Authors