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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Output Data must specify a sheet name

Meteoroid

Hello Everyone,

 

I've tried to have out put  excel file named IO KSB1 March.yxdb but for some reason I keep getting that I must specify a sheet name error message.

I've attached my workflow  and any help would be greatly appreciated.

 

 

Thanks in advance 

 

Marcelo

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Queirozm 

 

I'd suggest you to clean the file name.

Click on the down arrow at the right side.

Select File

Select the name of the file - and type of file Microsoft Excel (*.xlsx).

 

After that, a pop up asking you the name of the sheet will appear.

 

Cheers,

Alteryx Certified Partner
Alteryx Certified Partner

@Queirozm 

 

This happened probably because you did not specify a file name in the first place and just named your file.

It automatically changed to .yxdb type (Alteryx Database).

 

Then you tried to change to a .xlsx, and when you do that, this window asking for the name of the Sheet doesn't show up.

 

You can also add the sheet name by adding "|||SheetName" in front of the file name.

But in your case, you'd also need to change the extension to .xlsx instead of .yxdb

 

Cheers,

Bolide

Is this correct:

  You can also add the sheet name by adding "|||SheetName" in front of the file name   ?

 

or should it be....behind the file name?

Alteryx Certified Partner
Alteryx Certified Partner

@ChrisTX 

 

It's correct. The full file path of an excel table is in this format: Folder\file.xlsx|||Sheet1

 

Cheers,

Meteoroid

Hi Tableaus, 

 

 

It's working now, Thanks so much. 

Meteoroid

Hi Thableaus. 

 

 

Sorry, I didn't understand. Have I change the file name  or the  "sheet 1 ?  

 

I'm a rookie in this ALteryx and a I'm a little bit lost.

 

 

Cheers

Alteryx Certified Partner
Alteryx Certified Partner

@Queirozm 

 

"Sheet1" is not the filename. It's the Sheet name of your excel file.

 

The format, as an example, should be this: C:(or anyotherdrive)\Folder\ExcelFile.xlsx|||SheetName

 

Write it in your file path of your output tool and it will work.

 

Cheers,

Labels