Converting single input record into multiple output records
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What's the error criteria? When Field1 is an 'X' and, additionally, when Field2 is a 'Y'.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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").
