Find Value in other columns if Not Found in a column

[TFish]

Hi everyone,

I have a dataset for the Training Process, and I need to identify the False Fully Trained status for a process (the ones that are identified as Fully Trained, but not really). The logic of a True Fully Trained status is that at least 1 person has to be Fully Trained, and at least 1 other person (in another column) has to be either Fully Trained/Able to Run. There are 3 possible Training statuses for a person: Fully Trained, Able to Run, and Training Begun.

My draft logic for Alteryx to define the True Fully Trained Status is: Or (1 in 4 columns contains Fully Trained), And [Or (Or 1 in the rest 3 columns contains Fully Trained), (Or 1 in the rest 3 columns contains Able to Run)]. However, I don't know how to do a loop to find the Fully Trained value in 1 in 4 columns, and how to find Fully Trained/Able to Run in the rest 3 columns, as that would be quite dynamic. Please help. I have attached a screenshot and the sample data.

 

[Raj · Accepted solution]

@TFish 
find the workflow attached
mark done if solved.

[TFish]

Hi Raj,

Thank you for the solution. It was great and solved the problem I had. Only a small thing that I may have forgotten to point out is that there may be a case in which there are 3 Fully Trained employees, leading to the filter not working properly. However, it's a minor thing and I only want to point that out so that future readers of this post will be careful with that.

Other than that, thank you very much!