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

Alteryx Designer Desktop Discussions

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

Converting single input record into multiple output records

Jake5
8 - Asteroid

Hello,

 

I'm trying to build a workflow that will perform some basic validations and output the results.  Using the screenshot attached, assume each of the 3 fields were being checked for a valid value (via a formula tool).  Those values in red text are to denote an error.  My desired output would be to display a new "Error" column where it would inform which column had an error.  In this display, the input record has two errors in two columns respectively.  I would like for the output to parse this into two separate rows as shown.  Any suggestions on how to accomplish this?

 

Thanks in advance!

 

Jake5_0-1659984574586.png

 

 

 

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

What's the error criteria? When Field1 is an 'X' and, additionally, when Field2 is a 'Y'. 

Jake5
8 - Asteroid

For example, let's assume Field 1 is a required field and the user forgets to enter a value (so Null).  Then I would want the Error column to indicate the column where the error occurred.  I kept my original visual simple but I also intend to have another output column - next to the Error column - that will be labeled Error Type where it will reveal the type of error (i.e. "Required Field").  

Labels
Top Solution Authors