In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Can't open file:, The filename, directory name, or volume label syntax is incorrect.

Praneeth1996
8 - Asteroid

Hi team,

 

I am getting below error.

Error: Output Data (29): Unable to Open archive for zipping: Z:\CRS Bmth Migration\Depo Services Change\2023\FM UTs Remediation\DS Daily NAV Check\*BE DK FI NL NO SE*.xlsx Can't open file: Z:\CRS Bmth Migration\Depo Services Change\2023\FM UTs Remediation\DS Daily NAV Check\*BE DK FI NL NO SE*.xlsx: The filename, directory name, or volume label syntax is incorrect. (123)

 

Configuration is below. There is already a file named "BE DK FI NL NO SE DAILY NAV MOVEMENT.xls" and contains sheet "CurrentDaily"

 

Can you please help if I am missing something?

 

Praneeth1996_0-1687184736502.png

 

3 REPLIES 3
binuacs
21 - Polaris

@Praneeth1996 Can you try without the * and give the full name in the path .\BE DK FI NL NO SE DAILY NAV MOVEMENT.xlsx|||'CurrentDaily$A7:A2000', also make sure that the file exists in the same folder where you saved your workflow

flying008
15 - Aurora

Hi, @Praneeth1996 

 

The windows file name can't contain '*' character, so your  *BE DK FI NL NO SE*.xlsx is incorrect.  you need remove it or rename.

Divya1808
6 - Meteoroid

For example file name is : AUSTSUPERAU_APRAWorkBook_3312024_RunDate_04112024_070303 but this is dynamic and will keep on changing having only one thing constant i.e *_APRAWorkBook_* which I want Alteryx to search and give the output in the file

What can be done in such case?

 

Labels
Top Solution Authors