In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to filter out duplicate fields?

richleeb2
8 - Asteroid

I want to filter out the fields that have more than one instance.  For example below, I want the 2 dog fields to be filtered out.  I tried Unique tool, but this separates 1 dog as a unique field, and the other dog as a duplicate.  

Dog
Dog
Cat
Snake
3 REPLIES 3
PhilipMannering
16 - Nebula
16 - Nebula

I would check out the Only Unique tool, which is one of the CReW macros. You can download it here: http://www.chaosreignswithin.com/p/macros.html 

binuacs
21 - Polaris

@richleeb2 one way of doing this

binuacs_0-1681829925305.png

 

 

 

ShankerV
17 - Castor

Hi @richleeb2 

 

One way of doing this.

 

ShankerV_0-1681829830578.png

 

Step 1: Input

ShankerV_0-1681829887368.png

 

Step 2:

 

ShankerV_1-1681829905056.png

 

ShankerV_2-1681829914175.png

 

 

Step 3: 

ShankerV_3-1681829930599.png

 

ShankerV_4-1681829940869.png

 

Step 4:

ShankerV_5-1681829963640.png

ShankerV_6-1681829973535.png

 

 

Many thanks

Shanker V

Labels
Top Solution Authors