Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
adambrian
Contributor III
Contributor III

Find points (latitude,longitude) belong to which city

Hi,

I have 2 tables which are point of location (latitude,longitude) and area of country (kml format).
I want to link this tables but It don't have similar name or data. Can This tables be linked?
Anyone have any idea to solve it?

 

 

Table1:

adambrian_0-1592102907565.png

 

Table2:

adambrian_1-1592102938625.png

 

Thanks,
Adam

 

Labels (4)
1 Reply
lironbaram
Partner - Master III
Partner - Master III

hi 

if you have qlik geo analytics ,

which comes with Qlik professional license

after you load the two tables , 

you can use the within function in the Qlik Geo analytics connector 

it will find for each point the area that conatin it , and will create a table connecting the two tables