We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

dynamic output issue

petr__
7 - Meteor

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

petr___0-1619539819583.png

petr___1-1619540177099.png

 

 

set up output component

petr___1-1619539855701.png

 

 

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

 

petr___0-1619540129663.png

petr___2-1619540199358.png

 

 

 

 

...any idea ?? many thanks

 

 

4 REPLIES 4
jrgo
14 - Magnetar

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
17 - Castor
17 - Castor

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.

 



Bulien

petr__
7 - Meteor

Hello @jrgo 

 

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

petr__
7 - Meteor

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?

Labels
Top Solution Authors