We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

Summarize Yes and No

jingmu
5 - Atom

I have a dataset in which some of the columns are of yes/no. I wish to use the summarize tool where if there is at least one Yes in the column, return Yes, otherwise return No.

 

One way I used is to replace Yes/No to 1/0, then select the Maximum value for each column, then switch back to Yes/No. I am just wondering if I can do this with Yes/NO.

 

Thank you.

2 REPLIES 2
NicoleJohnson
ACE Emeritus
ACE Emeritus
You are correct, the Max of Yes/No will give you Yes, so you shouldn't need to convert them to numbers before the summarize tool! Just select Max for your Yes/No field and the results should give you Yes if there is at least one Yes in that column.

Cheers,
NJ
jingmu
5 - Atom

I just tried and it worked fine. I am glad to know the trick. Thank you very much Nicole!

Labels
Top Solution Authors