Return the Field Name

[YLYONG]

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

[YLYONG]

@Akash__on @atcodedog05 @apathetichell @SoccerTil @mceleavey thank you so much for your ideas and suggestions!

[atcodedog05]

Happy to help : ) @YLYONG 

If our response helps please don't forget to mark it as solution.

Cheers and have a nice day!