Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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