Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Validation for user inputs

hemant86
11 - Bolide

Good Day All,

 

I'm looking for a tool for Validation of column and show appropriate message to user for the validation. For example 

1. Col A to Col L should be blank if not throw a message to user saying the same its not blank.

2. Col M should not be future date and always be current date if not throw a message to user saying the same

And workflow should not proceed until the conditions are satisfied

 

Thanks in advance!!

12 REPLIES 12
hemant86
11 - Bolide

Hi @atcodedog05 

Is there any limitation to using Message Tool in the workflow. I'm using total of 16 tool for different columns to produce different messages. Its working fine until 13th but does not work from 14th.

I'm attaching sample of my workflow and the File. It would be great if you could take a look. 

atcodedog05
22 - Nova
22 - Nova

Hi @hemant86 

 

In your current data date> today and make sure to configure to stop processing on error.

atcodedog05_0-1635505839676.png

 

When I change the data they seem to work

atcodedog05_1-1635506077475.png

 

Hope this helps : )

hemant86
11 - Bolide

Thanks @atcodedog05 . I got the mistake I was doing. Rightly highlighted. I was not choosing the correct option from Message type. Thanks again🙂

Labels