Excel Output File to contain Dynamic file name and sheet name in output data

Question

Hi Folks, need some help please.

When  exporting I need the file name to be Inventory_IO_Report and the date the report was run / exported  example Inventory_IO_Report 2020.06.24,  and if I run on the 25, it shows the 25 and so on.  I have to save it to a shared server folder so Alteryx scheduler  can be auto-scheduled.   I also want to to use this output to load to  Tableau

Getting this error message from the Workflow.

Error: Output Data (27): Unable to Open archive for zipping:
\DUB-AV-FS01\Production$\16.  Industrial Technologies\16.16 Distribution Operations\12. MTS Stockouts & Future Stockouts\
Inventory_IO_Report.xlsx|||Sheet1Inventory_IO_Report"+_FileDate_ + ".xlsx Error Opening file:
\DUB-AV-FS01\Production$\16.  Industrial Technologies\16.16 Distribution Operations\12. MTS Stockouts & Future Stockouts\
Inventory_IO_Report.xlsx|||Sheet1Inventory_IO_Report"+_FileDate_ + ".xlsx
: The filename, directory name, or volume label syntax is incorrect.
 (123)

Thableaus · Accepted Answer

Hi @Karl_Spratt

You're mixing up single quotes with double quotes on your FileName expression.

Try to use just double quotes and make sure to close them properly.

Also, you should try to change the file path and not the file name.

Use an expression like this:

"\DUB-AV-FS01\Production$\16.  Industrial Technologies\16.16 Distribution Operations\12. MTS Stockouts & Future Stockouts\
Inventory_IO_Report" + [FileDate] + ".xlsx|||SheetName_" + [FileDate]

Change the option below to "Change Entire File Path" like this:

Cheers,