Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

pedrobergo
New Contributor III

QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset

Hello,

I'm testing the GeoAnalytics connector, I choose TRAVELAREAS function to identify the vendors overlapping areas. Always get this error message:


QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset AreaCliente: Malformed POINT geometry: -19.3101506.

[TravelAreas]:

SQL SELECT * FROM TravelAreas(dataset='AreaCliente',costValue='2',costField='',costUnit='Hours',transportation='car')

DATASOURCE AreaCliente INLINE tableName='Clientes',tableFields='CHAVE_CLIENTE,LATITUDE,LOGITUDE',geometryType='POINT',loadDistinct='YES',suffix='',crs='Auto' {CHAVE_CLIENTE LATITUDE LOGITUDE

0102205201 -19.3101506 -48.9277299

(...)

0103820901 -19.3101506 -48.9277299}

I check the post QVX_SYNTAX_ERROR Failed to process query Failed to create dataset  but its didn´t work for me.

Follow my connection parameters:

Screenshot_9.jpg

Where is the error? Can I fix this?

Tks,

Pedro

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset

Hi Pedro,

Choose "Latitude, longitude point" instead of Point.

The geometry type "Latitude, longitude point" is when there are two separate fields for latitude and longitude.

Point is a point string in one field: '[lat, long]'


Thanks,

Patric

2 Replies
Employee
Employee

Re: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset

Hi Pedro,

Choose "Latitude, longitude point" instead of Point.

The geometry type "Latitude, longitude point" is when there are two separate fields for latitude and longitude.

Point is a point string in one field: '[lat, long]'


Thanks,

Patric

pedrobergo
New Contributor III

Re: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset

Ok, It´s working now !

Tks a lot !

Pedro

Community Browser