Ouput Multiple xlsx files

Hi everyone,

Currently exploring how I can output multiple files from a workflow. I have multiple files of the same schema and I want to run them in one workflow. The same process applies to all files. Also, I need to output each files after each run in the workflow.

I have this design right now

What its doing is creating sheets per record. 😕 instead of creating xlsx file per input file

This is m standard macro.

I hope someone in the community can help me out.

NewWorkflow2.yxzp

Developer

Tips and Tricks

Macros

Accepted answers

afv2688

Hello @jogayon001,

The configuration is now set to save the file (as I gave it to you) on the same path the macro is stored. It is possible to do what you want, you would need to do two changes:

- On the filename put the entire path (C:/Users/Documents..../Filename.xlsx|||sheetname

- Change the output config to "Change entire file path". this configuration can be changed on the bottom part of the window, just beneath the "take file/table name from field"

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

All comments

DiegoParker

Hi Jogayon,

Unfortunately I can't open your workflow as I'm on a lower version of Alteryx but there are a couple of threads that have helped me in the past:

For the input:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/24946

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

For the output:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-data-into-multiple-files/td-p/142665

What I'd do is to select the "Output FileName as field" in your input tool (considering the share the same schema). Then I'd select the "Take FileName from field" in your output tool. The field I'd use would be that one generated in my input tool. Hope that makes any sense.

Best,

Diego

afv2688

Hello @jogayon001,

Please find attached a workflow showing how to do it. I attached also the dummy files I used:

You are more than welcome to get a more specific workflow for your case, but would need to get the data too (even if its a dummy)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

output_files.yxmd

Jan.xlsx

Feb.xlsx

jogayon001

Hi afv2688

I am able to create a sheet for the output. Thank you for the assistance. I have a little challenge though. I am getting an error in the output data tool "unable to open archive for zipping". Would you know the reason behind this?

Is it possible to save the output files in a separate folder? I want to create an output folder for all the files that have been executed in the workflow.

Thanks again.

test_Workflow1.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703