Good Morning expertise users,
Being a new bee to Alteryx, I am working on a workflow build for exceptions management. We get rejections on our report submission if one or multiple mandatory columns fail the validation due to blank fields.
In the attached example sheet,
scenario 1
I have the error fields column which has the column header name where there is no data. I am looking to go to that column, check if it is blank or #ERR (some of the fields will get populated with this). If that is the case, then mark it as Yes in the New exception column. Example in the first record, Instrument classification field is blank as per the error field. I would like to go and check the Instrument classification column to see if it is blank or #ERR. If it is the case, then want to populate Yes under the new exception column.
scenario 2
In the second line, its a different scenario where we will get multiple column header name appearing in the error fields and will have to check those columns for the same criteria as mentioned in scenario 1.
Note: I have simplified the examples and in the daily files, we have 203 columns with more than 6k rows on average.
Any help is much appreciated as I couldnt find anything similar posted in our community.
Thank you so much.
Vijay
