Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi row formula

Istwineres
8 - Asteroid

Hi, I have this situation:

A | B | C | D

----------------

x | y |  z | w

x | a | z | w

 

4 fields with multiple records but I'd like to handle this situation if 2 records or more have same values in same fields except one (in this example the B field) then filter out these records. The unique tool doesn't seem to have an utility here

 

 

10 REPLIES 10
afv2688
16 - Nebula
16 - Nebula

Hello @Istwineres ,

 

Hope this solution helps you.

 

Regards

Labels
Top Solution Authors