How to remove garbage rows in this scenario?

[Anonymous]

Here we can see name of the cities are repeating...For my scenario the name of the city arising for the first time is valid otherwise consider it as garbage value.Like 'Chak Forty M' is again repeating in 2nd and 3rd row, so here I want only 1st row to be loaded and 2nd & 3rd should avoided or deleted...How to achieve the same???

Thanks in Advance

Regards

Himanshu Kumar

[MarcoWedel]

you're right, FirstValue solves your problem:

tabCities:
LOAD City1,
    FirstValue(Latitude) as Latitude,
    FirstValue(Longitude) as Longitude
FROM [http://community.qlik.com/servlet/JiveServlet/download/516020-103612/Testinng.xls]
(biff, embedded labels, table is Sheet1$)
Group By City1;

Did I understand correct, that you found the solution on your own and do not have any other issues, or are there any questions left?

regards

Marco

[disqr_rm]

LOAD City, Latitude, Longitude FROM\Whatever.xlx.. WHERE Not Exists (City);