Hi Philipp, thank you so much the Video really interesting.
And if I do that I do need all the longitude and latitude of the each city.
How every, I can not find the prople file from google.
Went to AggData. ---they only have 20% matching (Swedish) city in my list
and went to
the file seems also not matching.
I also have changed the city names from all Uppercase to Sentence case to match the target file, but still, does not work.
Do you have any recommendation regarding which free database I can use to get the long&lati tude info about the Swedish city in my list?
and Do the 'Formate' of the city names matter regarding the matching/joining withing the qliksense?
Not the Category title but the name: e.g one file having: Stockholm ---the other have: STOCKHOLM
and sometimess there are may be a space or something in the file and how can I detact that and handle that for correcting matching?