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: 
Riccardo
Partner
Partner

CSV as dataset doesn't work

Hello,

I'm tring to use a csv as a dataset for intersect operation in geo operations SaaS.

Here is the code:

 

 

 

TABLE:
Load * Extension GeoOperations.ScriptEval('
  SELECT * FROM Intersects()
  DATASOURCE testpoints CSV 
  	  	url="https://www.dropbox.com/s/pt2j6nl0gz73h4o/testpoints.csv?dl=0",
    keyField="C_SEZ",
    geometryField="G_SEZ_CEN",
    fieldSeparator="COMMA",
    recordSeparator="NEWLINE",
    stringQuotes="DOUBLEQUOTE",
    encoding="UTF-8",
    geometryType="POINT",
    crs="Auto"
', TABLE_WITH_POLIGON_FROM_PRECEDING_TRAVELAREA);

 

 

 

but Qlik returns this error:

Connector reply error: grpc::StatusCode::INVALID_ARGUMENT: 'Failed to create dataset testpoints: Unknown geometry field in CSV, G_SEZ_CEN'

 

How can I resolve this issue?

Thanks

Riccardo

Riccardo Schillaci
BI Technical Analyst
Datawarehouse & Business Intelligence
Labels (1)
1 Solution

Accepted Solutions
1 Reply