Removing Duplicate & Null

[Chauche]

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

[FrederikE · Accepted solution]

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.

[messi007]

@Chauche,

Please see below : 

Attached the workflow,

Regards,

[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]).

[Emmanuel_G]

Hi @Chauche ,

Here's a simple solution which give desired output.

Let us konw if it works as you want.

Cheers !

[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.