Removing duplicates on loading - how to do?

[Anonymous]

I have loaded the following data into a Qlikview Model

ID	email1	email2	email3	Sex
12345	jazzy@gmail.com	jj@hotmail.co.uk	jazzy@gmail.com	F
23456	beano@yahoo.co.uk		beano@marks.com	M
34567	loopyloo@gmail.com	loopyloo@gmail.com		F
75432	fred.b.@ukmail.com	freddie@hotmail.co.uk	fred.bar@fedex.com	M

I wanted to keep only unique emails - how can I do this?

My output should look like this...

ID	email1	email2	email3	Sex
12345	jazzy@gmail.com	jj@hotmail.co.uk		F
23456	beano@yahoo.co.uk		beano@marks.com	M
34567	loopyloo@gmail.com			F
75432	fred.b.@ukmail.com	freddie@hotmail.co.uk	fred.bar@fedex.com	M

Any help gratefully received.

Thanks

JazzyK

[trdandamudi]

One way is as below:

Data:
Load ID,
email1,
If(email2=email1,'',email2) as email2,
If(email3=email2 or email3=email1,'',email3) as email3,
Sex;
Load * Inline [
ID, email1, email2, email3, Sex
12345, jazzy@gmail.com, jj@hotmail.co.uk, jazzy@gmail.com,F
23456, beano@yahoo.co.uk, ,beano@marks.com,M
34567, loopyloo@gmail.com, loopyloo@gmail.com,,F
75432, fred.b.@ukmail.com, freddie@hotmail.co.uk, fred.bar@fedex.com,M
];

[Anonymous]

Thank you - worked perfectly - so simple when I think about it...always learning

[trdandamudi]

You are welcome. Keep learning you will be better day by day.