community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

If all values are true for an option then return true else false

Hi everyone,

 

I am kind of stuck in this problem need your advise:

 

I have data that looks like this:

 

OptionValue
OPTION ATRUE 
OPTION ATRUE 
OPTION AFALSE
OPTION BTRUE 
OPTION BTRUE 
OPTION CFALSE
OPTION CFALSE
OPTION CFALSE
OPTION CFALSE
OPTION CFALSE

 

And I am looking for output like this

 

OptionValue
OPTION AFALSE
OPTION BTRUE 
OPTION CFALSE

 

Basically if all values for a particular option are True then set the value as true and if any value for a particular option is false set value as false and each option should have just 1 entry.

 

Thank you in anticipation of your advise. 

Alteryx Certified Partner
Alteryx Certified Partner

Try taking a Count of True by Option and a Count by Option and testing their equality.

 

See the attached example.

Alteryx Certified Partner
Alteryx Certified Partner
If you use the SUMMARIZE tool and the MIN function, you will get FALSE if it ever is and TRUE otherwise.

Thanks,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx Certified Partner
Alteryx Certified Partner

@MarqueeCrew wins

Alteryx Certified Partner
Alteryx Certified Partner

It was a photo finish @michael_treadwell  you can use the Racer X image and we can team together!

 

images.jpg

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Pulsar
 
Highlighted
Meteoroid
 
Labels