We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Validating correct input files selected In Analytics App

cwinkler
5 - Atom

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! 

1 REPLY 1
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

@cwinkler ,

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

DataValidation.png

Error Message

DataValidationError.png