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

Datasets

Macros

Common Use Cases

Accepted answers

Felipe_Ribeir0

Hi @AdwaitTarudkar

One way of doing this

Data cleansing.yxmd

All comments

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

Hi @AdwaitTarudkar

One way of doing this

Data cleansing.yxmd

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:

Data cleansing.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703