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

[Praneeth1996]

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?

[binuacs · Accepted solution]

@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 · Accepted solution]

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]

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?