Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Dynamic file output location showing up as corrupted when running workflow

JesH
8 - Asteroid

I have 2 output tools where a single excel file will be created with 2 different worksheets (Summary & Audit).

I used Parallel Block Until Done to ensure 'Summary' worksheet will be created first and then the 'Audit'

worksheet.

JesH_0-1620396109981.png

 

When I run the workflow, the Summary file is created successfully but the Audit output is causing an error, as the file name is being corrupted somehow, as seen below in the Results pane.

JesH_2-1620396226253.png

I am not sure why in the Audit output, the file location is being corrupted, as it looks ok within the workflow.

JesH_3-1620396316502.png

The output tool seems to be configured correctly. What am I doing wrong?

JesH_4-1620396365694.png

 

 

 

 

 

8 REPLIES 8
HomesickSurfer
12 - Quasar

Hi @JesH 

 

Does your filed specify a sheetname?

JesH
8 - Asteroid

@HomesickSurfer 

Yes, sheet name is specified. Forgot to add this in.

 

JesH_0-1620397616496.png

 

The formula output is getting corrupted when the workflow is run & Alteryx is trying to create an output:

JesH_0-1620397731995.png

 

 

HomesickSurfer
12 - Quasar

Hi @JesH 

 

I think your sheetname needs to be proceeded by a double pipe.  Eg. ||

Also, the 'ZAS' file is a generate Excel file when attemting to write to a file that is open to another user or process.

Check your output directory - you will notice it is there.

Close the file, ensure nobody is using it.

If still an issue, your (parallel) block until done is malfunctioning.

JesH
8 - Asteroid

@HomesickSurfer 

I've tried || & ||| but still the same issue.

 

JesH_0-1620399891419.png

Even moved my 'Parallel Block Until Done' to earlier in the workflow so that I know for sure that the output file is not being used when the Audit sheet is being written in..

JesH_1-1620399978276.png

 

HomesickSurfer
12 - Quasar

Hi @JesH 

 

May i see your configuration of he output tool?  Are you selecting 'preserve formatting' and without specifying a range?

JesH
8 - Asteroid

JesH_0-1620402216225.png

 

HomesickSurfer
12 - Quasar

Sorry @JesH  I can't figure it out

danilang
18 - Pollux
18 - Pollux

Hi @JesH 

 

Your first image shows a render tool.  Does this tool output to the same file as the two output tools?  If so, you should use a BUD to isolate it as well.

 

Dan

Labels