GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

Who Me Too'd this topic

OlivierS
Partner - Contributor III
Partner - Contributor III

GEOOP 401 ERROR on Qlik Saas

Hi,

I have the same error using the Qlik GeoAnalytic Connector for Interset and Within query.

I tried these function with very simple table to be sure of the syntax, i got you some screencap:

WithinError2.jpgWithinError3.jpg

 

 

Here is the scriptrequest:

[WithinResultTable]:
Load * Extension GeoOperations.ScriptEval('
Within()
DATASOURCE City INTABLE keyField="City_ID", crs="auto", pointField="City_LocationPoint"
DATASOURCE Country INTABLE keyField="Country_ID", crs="auto", polygonField="Country.Country_Name_GeoInfo"
', City);

 

So i basically trying to make the script work for a City ($Geopoint) Within a Country ($GeoPolygon). I receive this error:

L'erreur suivante s'est produite:
Connector reply error: grpc::StatusCode::INVALID_ARGUMENT: 'GEOOPS-401: Missing column in indata: Country_ID'

Emplacement de l'erreur:
[WithinResultTable]:
Load * Extension GeoOperations.ScriptEval('
Within()
DATASOURCE City INTABLE keyField="City_ID", crs="auto", pointField="City_LocationPoint"
DATASOURCE Country INTABLE keyField="Country_ID", crs="auto", polygonField="Country.Country_Name_GeoInfo"
', City)
Labels (4)
Who Me Too'd this topic