Dynamic Output Error

Question

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

2023-11-17_16-09-33.png

2023-11-17_16-07-48.png

apathetichell · Answer

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...

henrymk5 · Answer

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

SPetrie · Answer

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.