Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Workflow Outputting multiple excel files off the server

mmurph20
7 - Meteor

I have a workflow that creates multiple excel workbook, is there away to make it so all the sheets download off the server as you can when you output one excel workbook as shown in the attached image. Right now when we try to have multiple outputs in the workflow it does not give us this option on the server.

4 REPLIES 4
MatthewO
Alteryx
Alteryx

Hello @mmurph20:

 

In the Output Data tool you can check the Take the File/Table Name From Field option in the Configuration pane and then map the field containing the sheet name: A, B, C, or D. The records will be written to the corresponding sheet in the Excel file. 

 

filename.png

 

Attached is a simple workflow that illustrates the configuration.

mmurph20
7 - Meteor

Hi this made  four different tabs in one workbook when I ran it on the server. I would instead like it to make four different workbooks with one tab each (or in my case multiple tabs each) and download them from the server. Thanks! 

MatthewO
Alteryx
Alteryx

@mmurph20 the process will be the same. Two modifications to the workflow can achieve this result. 

 

In the Formula tool, the full file path and sheet name are specified. The example below writes everything to "Sheet1" but the sheet name could be generated based on a formula or field as well.

sheet.PNG

 

In the Output Data tool, change the action to "Change Entire File Path"

path.png

 

This will render the results to different files that can be downloaded. 

output.png

mmurph20
7 - Meteor

This worked perfectly thank you so much!