Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Data Validation

vijaylnyadav
8 - Asteroid

Hi,  

 

I have an assignment please refer the below sample and suggest a solution.

 

Total FeeFee 1Fee 2Fee 3
0 or Null122313213113213
221321NullNullNull
21352112121Null21431

 

Condition to check:

 

if [Total Fee] is blank or 0 then [Fee 1], [Fee 2], [Fee 3] should be populated and if [Total Fee] = some amount then all the remaining files can be left blank.

 

Please suggest a solution for the same

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @vijaylnyadav 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1606894476661.png

Workflow:

atcodedog05_1-1606894498977.png

Using validation formula on all columns.

 

Hope this helps 🙂 Feel to ask if you have any questions


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

vijaylnyadav
8 - Asteroid

Hi,

 

I want to save the value as error in another column and does not manipulate any of the values in present column.

atcodedog05
22 - Nova
22 - Nova

Hi @vijaylnyadav 

 

Are you looking for something like this

atcodedog05_0-1606894959658.png

Workflow:

atcodedog05_1-1606894985868.png

Hope this helps 🙂 Feel to ask if you have any questions


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

vijaylnyadav
8 - Asteroid

i want an another column as a Error/Validated if the condition full-fills then its value is "validated "and if not then its value is "error" 

atcodedog05
22 - Nova
22 - Nova

Hi @vijaylnyadav 

 

Something like this.

atcodedog05_0-1606895508134.png

Workflow attached.

 

vijaylnyadav
8 - Asteroid

Thanks for your help

 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @vijaylnyadav 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

Labels