How to spit out multiple xlsx files instead of csv in Alteryx

[blitz45]

Hi everyone! 

I have a workflow that's connected to some tables in our database. I need to have my workflow to spit out multiple files in xlsx format by appending a field name in my workflow. I am able to spit multiple files out with csv but when I try to do that with xlsx, it splits them into tabs in one spreadsheet. 

Any suggestions? we're looking at spitting out about 7,000 files into one location. 

[AngelosPachis · Accepted solution]

Hi @blitz45 ,

You can use a formula tool before your output to create a new column with the complete Filepath.

In my example, I have the file names in the column "Field 2" and I have decided to save the files on my Desktop. 

Then in your output tool, make sure that you select to change the entire file path based on the field you have created in the formula tool

You can unselect the Keep Field in Output checkbox, to drop the column Filepath in your output.

Hope that helps, let me know if that worked for you.

Regards,

Angelos

[blitz45]

@AngelosPachis  This is EXACTLY what I needed! THANK YOU SO MUCH! 

[AngelosPachis]

No worries @blitz45 , take care