Qlik Community

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Maaike
Partner
Partner

GeoAnalytics QVX_SYNTAX_ERROR

I'm getting an syntax error: Connector reply error: QVX_SYNTAX_ERROR: Failed to process query: Failed to create dataset Stations_geo: Malformed POINT geometry: ntb.

'ntb' occurs only once. How can I skip this row? 

Maaike_0-1629203942391.png

 

[IntersectsTable]:
SQL SELECT * FROM Intersects(dataset1='Stations_geo',dataset2='GGO_geo')
DATASOURCE Stations_geo INLINE tableName='GGO_stations',tableFields='gstat_afkorting,gstat_geometry',geometryType='POINT',loadDistinct='NO',suffix='',crs='Auto' {$(Stations_geoInlineTable)}
DATASOURCE GGO_geo INLINE tableName='GGO_GIS',tableFields='Gebied_GGO_id,Gebied_GGO_id_Geometry',geometryType='POLYGON',loadDistinct='NO',suffix='',crs='Auto' {$(GGO_geoInlineTable)}
SELECT * FROM Stations_geo
SELECT * FROM GGO_geo;

 

Labels (3)
1 Solution

Accepted Solutions
Patric_Nordstrom
Employee
Employee

I meant filter the table at load,  before running the Intersect operation, 

 

Thanks,

Patric

View solution in original post

3 Replies
Patric_Nordstrom
Employee
Employee

Skip the row when loading using a where clause.

Thanks,

Patric

Maaike
Partner
Partner
Author

Thanks Patric!

I am not sure where to add the where clause - I don't seem to get it working. 

Patric_Nordstrom
Employee
Employee

I meant filter the table at load,  before running the Intersect operation, 

 

Thanks,

Patric

View solution in original post