How to stop overwriting over files in Azure Blob Storage area

Question

I have an Alteryx app in which it writes a file to an Azure Blob storage area at the end of a certain period using the download tool.

I need the workflow to display an error message if the file already exists.

The workflow changes the name of the file using user inputs, ensuring that a file for a different period will be written as intended. However, users should only be able to write a file for one period once. So need to get rid of overwrite functionality.

Data_Alter · Answer

Thanks Owen, no we use the standard Download tool to write the data and we are not yet on the latest version of Alteryx.

TheOC · Answer

Hi @Data_Alter 
Could you let me know if you are using the Azure Data Lake File Output tool to create your outputs to Azure Blob?

Unfortunately, I am experiencing a bug with attaching screenshots on the Community, however under the 'options' tab, there is 'existing file action' - with an option to Abort if the file already exists.

In the case you need an error message to appear, you could utilise a control container (https://help.alteryx.com/20231/designer/control-container-tool) to grab the metadata of the tool and create an error in a Message Tool in the case that the operation is aborted.

Kind Regards,

Owen