Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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