Create new folder and add output file

[GvdHeiden]

Hi All,

I am trying to create a new folder in a dynamically pathed directory and write output to this new folder. However, Alteryx doesn't recognize that the folder is created in the workflow. Giving an error that it cannot access the newly created folder.

The alteryx flow does create the folder, and after running the workflow again Alteryx adds the output file as it is able to find the new folder.

So far I have tried to put a 'sleep timer' on the workflow, which didn't help.

Do you know a way to resolve this issue and add the file to the newly created folder?

I added an example flow in the disclosure.

[binuacs]

@GvdHeiden Your workflow working fine for me. can you check your path again from the log?

[PhilipMannering]

@binuacs Doesn't work for me the first time because it does try to output the filename first (at least for me and @GvdHeiden )

@GvdHeiden Try the attached soultion. I update output filepath dynamically.

[bgenc]

This worked perfectly Philip! Making the output path dynamic in the output tool fixed it.

Many thanks everyone!

[PhilipMannering]

Good stuff. Make sure you approve my comment as a solution, so that other people know it worked ...but more importantly give me the kudos! :)

[suby]

Hi Philip,

Trying to learn the workflow and when i try to run the workflow i get an error from the execute.bat and the Output.yxdb could you please suggest if i have to do any additional configuration on my local to test the functionality of this workflow.

[PhilipMannering]

@suby You shouldn't need to change anything. Maybe make sure it's saved somewhere you have permission to write to.

Did you change any of the workflow?

What is the error message you're getting? If you share the errors and some screenshots it's easier for me to troubleshoot.

[suby]

Hi Philip,

Thanks please find the attached the screenshot of the error.

[PhilipMannering]

Hmmm... sorry @suby I'm not sure. One thing you could try is running the same commands in an actual command prompt to see if it works outside of Alteryx.

[suby]

Hi Philip,

Do you mean which command ? i can't see the bat file command..