Creating folder structures is about the last thing left for Alteryx to automate... until now!
I've faced this issue a couple of times. I am trying to output to a location using this setting on an Output Data tool:
But the folder structure does not exist, and i receive the following error:
Now without some Alteryx Wizardry, I would need to manually create this folder path, before running the workflow again. This can be frustrating when uploading a workflow to the server, or receiving this error after running a long workflow.
What I have created, is a tool that ensures this path is created prior to outputting. Its as simple as adding the tool before the output:
And specifying the field that contains the folder path:
and hit run:
And you can see, it has successfully written a file to that location.
Do let me know if you run into any issues with the tool and I'll get them fixed as soon as I can.
Thanks,
TheOC