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

Removing data

vivian123
7 - Meteor

Hi all, 

 

What is the best way to remove rows based on a values in another column in this situation?

If there is more than one purchased item per customer then I want all data for that customer removed. 

 

Input table

Customer IDPurchased item ID
123666
123999
234111
456888
789555

 

Output table

Customer IDPurchased item ID
234111
456888
789555

 

Thanks

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

Maybe something like this.

Capture1A.PNG

vivian123
7 - Meteor

Thanks!!

 

Labels
Top Solution Authors