topic Re: Workflow Outputting multiple excel files off the server in Alteryx Server Discussions

Workflow Outputting multiple excel files off the server

Inactive User — Tue, 14 Dec 2021 16:16:33 GMT

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.

Re: Workflow Outputting multiple excel files off the server

MatthewO — Tue, 14 Dec 2021 19:41:02 GMT

Hello @Inactive User:

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.

Attached is a simple workflow that illustrates the configuration.

Re: Workflow Outputting multiple excel files off the server

Inactive User — Wed, 15 Dec 2021 14:49:17 GMT

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!

Re: Workflow Outputting multiple excel files off the server

MatthewO — Wed, 15 Dec 2021 15:05:53 GMT

@Inactive User 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.

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

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

Re: Workflow Outputting multiple excel files off the server

Inactive User — Wed, 15 Dec 2021 16:09:47 GMT

This worked perfectly thank you so much!