Unable to Open Archive For Zipping- Multiple Sheets Different Files

I have a data set that I want to breakout based on a column into different Excel files. In my example it will be over 100 Excel files. I am able to add them as new tabs to the same file but when I try and have the sent to a new stand alone file I get the error: Unable to Open Archive For Zipping

I only get output for the first Excel file and then the error message.

I have this formula created for the File Name:

"\C\TEST\" + [COLUMN NAME] + ".xlsx|Sheet1"

I am sure I am missing something small but I cannot figure out what it is.

Common Use Cases

Accepted answers

suli

Hi @dkashmo,

Do your column values (which get transformed into file name) have some spaces or special characters? As far as I remember spaces in the file path may cause some trouble. You can also try to add Sheet name with $ at the end and in this special quota `` (before 1 on the keyboard, under tilde).

If you need to dynamically create folders - this is possible with command line tool.

Hope this helps. If not you could also try to attach screenshot of the error message?

Good luck!

All comments

JordanB

Hi @dkashmo

During my tests everything looks good except the file location you are writing too.

Alteryx will not create a folder if it does not exist. So if you can make sure you have a TEST folder and correct file path for 'C' this should work.

I would suggest testing with this first: "C:\Users\[USERNAME]\Desktop\"+[ColumnName]+".xlsx|Sheet1"

Best,

Jordan Barker

Solutions Consultant

suli

Hi @dkashmo,

If you need to dynamically create folders - this is possible with command line tool.

Hope this helps. If not you could also try to attach screenshot of the error message?

Good luck!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167