This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
I'd suggest you to clean the file name.
Click on the down arrow at the right side.
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.
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
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?
It's correct. The full file path of an excel table is in this format: Folder\file.xlsx|||Sheet1
It's working now, Thanks so much.
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.
"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.