Excel Output Ghost Error, how to get rid off file is generating fine.

[BAvitia23]

Greetings

I'm experiencing some strange Alteryx behavior, running Version: 2022.3.1.486 Patch: 3

The error shows once I do the Excel Output, it's like a Ghost Error of a previous version or run, because that file path is does not exists, and I check the file it was generated fine from the tool, it just shows both it was generated and that it failed for archiving for zipping something different.

I have it configured in a formula to replace the entire file path.

Appears that at some point there was a wrong path created, and now I can't seem to get rid of the error, 

In the screenshots attached you can see that Output Data 146 Created the file and the records and at the same time it is telling me this error:

Output Data (146) Unable to Open archive for zipping: H:\Beatriz Avitia\Labor JE\Outputs\10.6\.23 Pivots Validation.xlsx Can't open file: H:\Beatriz Avitia\Labor JE\Outputs\10.6\.23 Pivots Validation.xlsx: The system cannot find the path specified. (3)

How can I get rid of the ghost error message if Its now doing what I need and there is really no error. 

[PangHC · Accepted solution]

i think it have at least a line of [PD] is "10.6\.23"

which cause the alteryx to search for folder of "10.6" in outputs and generate file with .23 Pivots Validation.xlsx

H: > Beatriz Avitia > Labor JE > Outputs > 10.6 > .23 Pivots Validation.xlsx

you can use some tool to replace/remove the "\"

[caltang]

@BAvitia23 I agree with @PangHC 's assessment. One of your records must have had an additional "/" thrown in, thereby causing Alteryx to look for a phantom folder, which results in your error. Can you check your formula of your outputh path again?

The field you're referencing ([PD]) is causing the issue I believe.