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