Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Filter columns based on multiple criteria, retaining all

schaeefer
5 - Atom

I have a dataset with 3 columns -

 

1. Customer

2. Product

3. Amount

 

There are multiple products and I want to filter to see if Customer has product X what other products do they have i.e. if they have product X and value is not 0 what other lines of data for that customer are in the dataset.

 

i don't want to just filter on product X I also want to see all the lines of data for Customers who happen to have product X

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @schaeefer 

 

If i understood correctly

 

1-You can filter product = X, then you will have all customers that bought it.

2-You can join 1 with your dataset by customer

 

customer.png

 

Labels
Top Solution Authors