Find Value in a row then create insert new value into new column

Question

Hello all, I'm trying to build an overall "Final" Column, I want this to basically look through every row, and if there is any "No Match"  in that row, then I want "No Match" To display in the "FINAL" Column, if all are "match", (or no match does not appear at all), I want "Match" to be output in the Final column for that row, any idea what tool I should use to approach this? Any tips at all would be appreciated not having much luck with formula.

T_Willins · Accepted Answer

Hi @dberroth,

This workflow should work.  I used a Dynamic Select tool so it can be scaled for additional Reason Code fields.  Using a Transpose tool with Summarize tools makes it easier to look at summarized data, then join the results back to the original data.  Let me know if you have questions.

Qiu · Accepted Answer

@dberroth 
Kindly check this is what you want.
It may be better to paste a text sample rather than snapshot, took me some time to prepare the sample data😁

Qiu · Accepted Answer

@dberroth 
We can modify the formula to

if contains([_CurrentField_],"No Match",1) or contains([_CurrentField_],"No",1) then 1 else 0 endif

But I am sure it is really good to do so, since the checking "No" will supersede the checking for "No Match".
Anyway, updated workflow attached for your reference.