Writing to Excel - Different tabs based on field value

I'm trying to write my data to excel with 1 tab per supplier name which comes from the data.

I'm getting an error about unable to open archive for zipping, but can not for the life of me figure out why it is throwing that error.

Flow in screenshot.

What am I doing wrong?

Error Message

Accepted answers

Hello @TeamTJ ,

You need not to pass full path as per current scenario you are trying to give full path as tab. You only need to pass the vendor field that you are using in your dataset and replace it with Test field that I am using in the screenshot by following the configuration mentioned below.

Thanks!

All comments

Two things I would look at one:

You dont shouldn't have.xlsx in your sheet name

And Two looking at this post Solved: Re: Unable to Open Archive For Zipping- Multiple S... - Alteryx Community:

Make sure you don't have any strange characters in your file path eg. :

Hello @TeamTJ ,

You need not to pass full path as per current scenario you are trying to give full path as tab. You only need to pass the vendor field that you are using in your dataset and replace it with Test field that I am using in the screenshot by following the configuration mentioned below.

Thanks!

Thank you!

Once I changed my bottom formula to just the field and not the path to the file, it worked!

I am glad that it worked for you.

Quick Links

Tags

This months top contributors

Hollingsworth 335