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

Alteryx designer Discussions

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

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