dynamic output issue

[petr__]

Hello I tried to simulate excel dynamic output for 2 excel sheets according this example

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-Rename-Excel-File-Output/t...

but it failed, I have everything set up correctly

variable with file name

set up output component

I also tried to switch 'a.xlsx|||sheet1' -> 'a.xlsx|sheet1'

and switch CHANGE ENTIRE FILE PATH -> CHANGE FILE/TABLE NAME

and combinations of these possibilities but it failed

...any idea ?? many thanks

[jrgo]

Hi @petr__ 

Here's the things that come to mind:

• Anti-Virus or Data Encryption software is starting its scan/encryption process after the first sheet is created
• Your output is to a protected system folder
  • If allowed, launch Alteryx as admin
• Your output is to a cloud file service (OneDrive, Box, etc...) and is starting to sync after the first sheet is created
  • Not common, but I've seen it happen

My money is on the 1st, AV/DEP.

[mceleavey]

Hi @petr__ ,

the first thing I would mention is you're changing the entire filepath, but only defining the file name in the first instance. This means you're not defining the path to which the file is being output, and so it would attempt to output to the temp engine folder, and if you don't have access to that it will fail.

Secondly, replacing the file name only will result in the .\ being retained, which means it's now relative to where the workflow is saved. If you haven't saved the workflow it was also fail.

Thirdly, you overwriting a specific sheet, so that sheet needs to already exist on the output file, so ensure you have created the file first and named the tab "sheet2" (lower case).

Check those things and see if any of them fix it.

M.

[petr__]

Hello @jrgo 

thanks for tip, but it is not caused by this things

[petr__]

Hello @mceleavey 

thanks for advices, but it doesn t help 😞

1) output is located of temp file

2) WF is saved in the available folder

3) overwriting works only sometimes or only when the file doesn t  exist, otherwise it cause an error, possible bug?