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