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
20 - Arcturus

@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