Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
LOAD City, Latitude, Longitude FROM\Whatever.xlx.. WHERE Not Exists (City);