Finding Adm2 names for a list of locations

[paolo_cordini]

Hello

I have the following scenario: I have a list of Cities, belonging to different countries. I have the Country field correctly aligned in my rows.

I want to find the "Administrative Level 2 " each city belongs to.

I tried to use the "Within" operation, with cities as enclosed dataset  (formatted as 'City:P*,Country') and Adm2 level as enclosing dataset.

This is working in principle, but the problem is that the resulting (enclosing) dataset is not limited to the areas corresponding to my cities, but  it contains ALL possible Level2 areas in the world. But the possible Level2 Areas are more than 20.000, so I get an error from the connector.

If I use the same method to find the Level1 enclosing area this is working because the returned rows are less than 20.000.

I can specify the country for the enclosing dataset, but as far I understand it can be only a fixed value (like 'US'), not a value aligned with the City.

Any idea?

Thank You
Paolo 

[Patric_Nordstrom · Accepted solution]

Use the NamedPointLookup operation.

Doc: https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoConnector/Content/connector/connector-geoanal...

Example: https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Connector-Examples-Qlik-GeoAnalytics/ta-p/...

In GeoOperations, there is no single operation called NamedPointLookup in GeoOperations,
use instead Load and INTABLE as source and namedPointField

Thanks,
Patric

[paolo_cordini]

Thank you for the answer.

The reason why I tried ad first with Within operation is that I needed the Name of the Admin2 level area. NamedPointLookup returns only "Adm2Code", whereas Within returns the area name as well.

I guess I will have to use the operation two times to get the Admin2 code and then the name.

Thank You
Regards
Paolo