Remove duplicates in QlikView Script

[GeorgePhilips2302]

City field  in the attached file has duplicate values with different geographykey values,

I want to remove the duplicates and keep one unique city with any one geographykey.

Variety of solutions expected!

[QFabian · Accepted solution]

Hi @GeorgePhilips2302 , please check this.

In this case, there is no duplicate, because they are different State 

116	Augsburg	Bayern	Germany
137	Augsburg	Hamburg	Germany

But for the rest works properly, or do you need not to consider the field State for the duplicates?

This is the Script that i made for you :

Data:
LOAD distinct
City,
State,
Country,
min(GeographyKey) as GeographyKey
FROM [..\Users\Qlik\Desktop\Remove duplicates.xls]
(biff, embedded labels, table is Sheet1$)
Group By
City,
State,
Country;

[GeorgePhilips2302]

This works but the geographykey which had duplicates are now showing null, how can i remove them off completely, Refer attached file.

[QFabian]

@GeorgePhilips2302 maybe that values comes from another tabla with that field, making a key ?

Then you can hide that values in your chart

[GeorgePhilips2302]

Okay, Thank you buddy!