We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Data cleansing

AdwaitTarudkar
8 - Asteroid

Hi all 

 

I want to covert this input 

AdwaitTarudkar_0-1668750037825.png

into 

AdwaitTarudkar_1-1668750110066.png

So, basically, I want to remove any duplicate in a single record.

Please ping me if you need further information.

 

Thanks 

Adwait

5 REPLIES 5
ShankerV
13 - Pulsar

@AdwaitTarudkar 

 

It is possible, can I build the solution for the below sample.

 

Or do you need to apply it for a huge dataset.

 

Many thanks

Shanker V

ShankerV
13 - Pulsar

Hi @AdwaitTarudkar 

 

Please find the solution for your blocker.

 

ShankerV_0-1668752307197.png

 

Many thanks

Shanker V

Felipe_Ribeir0
15 - Aurora

Hi @AdwaitTarudkar 

 

One way of doing this

Felipe_Ribeir0_0-1668752570927.png

 

ShankerV
13 - Pulsar

@AdwaitTarudkar 

 

Step 1: 

ShankerV_0-1668752816087.png

 

Step 2:

ShankerV_1-1668752838044.png

 

Stpe 3: 

ShankerV_2-1668752860042.png

 

Step 4:

ShankerV_3-1668752877663.png

 

Step 5:

ShankerV_4-1668752895296.png

 

Step 6:

ShankerV_5-1668752935377.png

 

 

Result:

ShankerV_6-1668752957612.png

 

Shanker V

KrishnaChithrathil
11 - Bolide

@AdwaitTarudkar 

Hi there,

Please give it a try.

INPUT: 

KrishnaChithrathil_0-1668756521764.png

 

OUTPUT:

KrishnaChithrathil_0-1668755970987.png

KrishnaChithrathil_1-1668756562720.png

 

 

 

Labels