Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
Thank you - worked perfectly - so simple when I think about it...always learning
You are welcome. Keep learning you will be better day by day.