Dynamic Output Error

[henrymk5]

Hello,

I am hoping you could assist with an error that I'm receiving. I am trying to output dynamically into different folders for each run. My Output Tool has 'Take file/Table Name from Field' selected and I'm pulling in the field with the full filepath.

The issue: My solution works but once the folder listed in my 'Write to file' is deleted or changed in my directory I receive an error.

For example - I have a folder dated 2023.06.06 and in my formula I have it set dynamically to locate the 2023.06.04 folder. This solution works until I delete the 2023.06.06 folder in my directory.

My thought was the output tool would ignore the original file path given I'm giving it a new location to output.

Hoping someone could assist. 

Thank you

[SPetrie]

If you are giving it the full path, you should indicate that in your output tool.

The other issue you will run into is that the output tool will not create a folder. The folder has to exist before you can write to it.

One method to get around it (Im sure there are others but this is what I use) is to use a run cmd to create the new folders just before output.

[henrymk5]

Hi @SPetrie I will be creating the folders allowing for the folder and file to exist. Every day we will create a new folder and a interface tool will update my full file path formula with that respective date. This method works fine until I happen to delete the folder date that is inputted into the Output Tool 'Write to File' location 

[SPetrie]

If we are sure the folders will be there, try just the first suggest of "Changing Entire FiIe Path" instead of "Change File/Table Name" that is shown in your screenshot. 

[henrymk5]

Thanks for pointing out the error, but I still receive the error message with Change the Entire File Path.

[apathetichell]

What versoin of Alteryx are you running? If you are running a 2023.X version - downgrade to 2022.X

..

2023.X requires downstream locations/files to be created/verified when opening...