community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Output Data must specify a sheet name

Atom

Hello Everyone, I am trying to have the output file named Dec 12_BWW Sales Report, but for some reason I keep getting that you must specify a sheet name error message. I have attached my workflow and any help would be greatly appreciated.

 

I have looked at all the other solutions regarding this issue and non seemed to solve my problem.

 

Thanks in advance,

 

Cyrus

Alteryx Certified Partner
Alteryx Certified Partner

you have this:

 

C:\Users\csakha\Documents\SandBox\'Test.xlsx|||Sheet1'

but need this:

 

C:\Users\csakha\Documents\SandBox\Test.xlsx|||Sheet1

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Atom

Hi Mark,

 

Thank you for your prompt response. I have tried without the '  ' and it still give me the same error message.

 

Regards,

 

Cyrus

Nebula
Nebula

Hi @CSakha

 

Your output is set to change the entire file path using the period column.  

 

Output.png

 

Your Period field currently doesn't include the sheet name

 

Formula.png 

 

Add the sheet name to end of the string 

 

IF     [Month]='01' THEN 'Dec P12_BWW Sales Report|||Sheet1'

If you need the period field to display in the data, create a new filename field with the sheet name and use this new field as the source for output filename

 

Dan

 

Atom

Thank you so much @danilang.

 

It worked perfectly!!!

 

Regards,

 

Cyrus

Meteoroid

By end of string do you mean replacing "Dec P12_BWW Sales report" with 

'Dec P12_BWW Sales Report|||Sheet1'
?

 

Labels