We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multiple files in one report

tiverson
8 - Asteroid

I have a workflow that has created the following three files.  I want to join these files into one report using the reporting tool.  

My main issue is my second report's output is one listing, however I need to create a tab for each Company.

 

1st file (this was created by joining report text and a table)

tiverson_0-1647785551803.png

 

2nd file (this is the report that I need to break out by each company (column A)

tiverson_1-1647785612833.png

 

3rd file

tiverson_2-1647785636891.png

 

2nd file desired output

tiverson_3-1647785733252.png

 

16 REPLIES 16
Aguisande
15 - Aurora
15 - Aurora

Sure.. find them attached.

 

Aguisande
15 - Aurora
15 - Aurora

What happens if you click Yes on Excel?

tiverson
8 - Asteroid

@Aguisande When it run the workflow, the first summary sheet is fine, but the other tabs are blank.

I attached the Excel output file settings below:

tiverson_0-1647894106486.png

 

tiverson_2-1647894329726.png

 

tiverson_3-1647894375560.png

tiverson_4-1647894388529.png

 

 

 

tiverson
8 - Asteroid

 Even when I run your workflow and change the output to my computer, I receive the same Excel message

Aguisande
15 - Aurora
15 - Aurora

That's weird.. What version of Alteryx you're on?

tiverson
8 - Asteroid

2021 2.2.45235

 

tiverson_0-1647898434104.png

 

Labels
Top Solution Authors