Hi
I have been using excel index match to return the field name of a matching value. Wanting to know how this can be done in Alteryx?
Thank you for your assistance
Input
ITEM | Height Check | Weight Check | Diameter Check | Passed All Checks | Reason for Failing ( Pick one only) |
A | 1 | 0 | 1 | FAIL | Height Check |
B | 1 | 0 | 0 | FAIL | Height Check |
C | 1 | 1 | 1 | PASS | |
D | 0 | 1 | 1 | FAIL | Weight Check |
E | 1 | 1 | 1 | PASS |
Output
ITEM | OUTPUT |
A | FAIL - Height Check |
B | FAIL - Height Check |
C | |
D | FAIL - Weight Check |
E |
Solved! Go to Solution.
@Akash__on @atcodedog05 @apathetichell @SoccerTil @mceleavey thank you so much for your ideas and suggestions!
Happy to help : ) @YLYONG
If our response helps please don't forget to mark it as solution.
Cheers and have a nice day!