Hi There, I have below scenario where I need to remove null rows (complete row and remove all the duplicate values from the "Concat_field" Any quick help is appreciated. IdentifierConcat_fieldnullates;aeg;13fefnullagergaegaw123;grp;123;grp;rtsagwetwegrts;rts;rts;rts;ypr;ypr;ypragwegwmgyjagrgawejfuty;setrefaerwg896jyjy

Removing Duplicate & Null

Hi There,

I have below scenario where I need to remove null rows (complete row and remove all the duplicate values from the "Concat_field"

Any quick help is appreciated.

Identifier	Concat_field
null	ates;aeg;13fef
null	agerg
aegaw	123;grp;123;grp;rts
agwetweg	rts;rts;rts;rts;ypr;ypr;ypr
agwegw	mgyj
agrgawe	jfuty;setref
aerwg	896jyjy

Transformation

Preparation

Accepted answers

FrederikE

To remove the null rows, a regular Filter should do. If you want to remove duplicates from the Concat field (I guess any duplicates within one cell, right?), then I would split it (Split to Columns Tool) and then use a "Unique Tool on both columns.

See the attached WF.

New Workflow9.yxmd

All comments

See the attached WF.

Please see below :

Attached the workflow,

Regards,

Filter_20220711.yxmd

DataNath

How does something like this look @Chauche? In the filter I've used 'null' but if the records are actually null rather than the text 'null' just change [Identifier] != 'null' to !isnull([Identifier]).

Remove nulls or repeats.yxmd

Emmanuel_G

Hi @Chauche ,

Here's a simple solution which give desired output.

Let us konw if it works as you want.

Cheers !

Flag rows.yxmd

Chauche

Thanks each of you. I could get the best way to get my result. @frederikE your solution was a optimal one I must say.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703