Converting single input record into multiple output records

Question

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 · Answer

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").

philipmannering · Answer

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