GeoAnalytics QVX_SYNTAX_ERROR

[Maaike]

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? 

[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;

[Patric_Nordstrom]

Skip the row when loading using a where clause.

Thanks,

Patric

[Maaike]

Thanks Patric!

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

[Patric_Nordstrom · Accepted solution]

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

Thanks,

Patric