Data cleansing

[AdwaitTarudkar]

Hi all 

I want to covert this input 

into 

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

Please ping me if you need further information.

Thanks 

Adwait

[ShankerV]

@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]

Hi @AdwaitTarudkar 

Please find the solution for your blocker.

Many thanks

Shanker V

[Felipe_Ribeir0 · Accepted solution]

Hi @AdwaitTarudkar 

One way of doing this

[ShankerV]

@AdwaitTarudkar 

Step 1: 

Step 2:

Stpe 3: 

Step 4:

Step 5:

Step 6:

Result:

Shanker V

[KrishnaChithrathil]

@AdwaitTarudkar 

Hi there,

Please give it a try.

INPUT: 

OUTPUT: