Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Determining If A Value Exist in A Group

Chitowndivaus
7 - Meteor

Afternoon All...

 

I have a group of data where I'm trying to determine if the group contains a particular value:

 

Store No        Ownership

1                     1220

1                         20

1                       890

2                     1220

2                         20

3                     1220

3                       890

4                         20

4                       890

5                       890

5                       890

 

What I'm trying to figure out is the group (Store No.) that does not have an 890 record, the group that has only an 890 record and the group that has an 890 and either a 20 or 1220 (but not both).  

 

I know I'm probably making this harder than it is, but I need help thinking through this.

 

It's probably like wrapping a gift, it's really simple, but you tend to make it more complex than it really is.

 

Any help would be greatly appreciated.

 

Thanks in advance.

 

2 REPLIES 2
TonyA
Alteryx Alumni (Retired)

I wasn't sure about some of the conditions (what about 890, 1220, and something else other than 20?) but this should get you started.

Chitowndivaus
7 - Meteor

Perfect!  This is exactly what I need!

 

I never thought about the cross tab tool--I learned something new!

 

Again, thanks so much for your help!!

Labels