I am currently working on an analytics app stored on Alteryx Server that takes several CSV files selected by the user, transforms and formats the data, then uploads to a Snowflake table. Since the input files have similar fields, formatting, rows, etc., I want to build in a validation layer that checks to ensure the correct file was select for the correct stream and ultimately appended into the correct table in Snowflake but I'm having trouble designing this step with the right tools. If an incorrect file is selected, I want the workflow to prompt the user that their selection is incorrect, and to select the correct file.
Any help would be appreciated!
There might be some variation depending on the validation logic to know the "incorrect file".
But you can use Control Container to branch the process with the result of validation as below:
In this case, if the record count is less than 1000, the App stops processing and output message.
Workflow
Error Message