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

Alteryx designer Discussions

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

Output Data must specify a sheet name

Meteoroid

Having a nightmare getting the output data tool to work the way I want it to!

 

I've got a data series that I would like to write to a blank .xlsx file but I keep having an error that tells me I "Must specify a sheet name" but as far as I can tell I have.

 

Data Output 2.PNGData Output 1.PNG

 

Am I doing something obviously wrong?

Alteryx Certified Partner
Alteryx Certified Partner

@JakeDear,

 

Is your MPAN always going to contain a value (e.g. NOT Null)?  If you have a null value in that field, this error makes sense.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

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

Nailed it, silly error on my part - thanks!

Atom

I am getting the same error, but don't understand the previous person's solution. Nothing is working for me. 

Meteoroid

Try adding a filter before your output to remove any NULL/Blank values

Atom
 
Labels