CSV as dataset doesn't work

Riccardo — Wed, 29 Jan 2025 15:35:54 GMT

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

Re: CSV as dataset doesn't work

Patric_Nordstrom — Thu, 19 Nov 2020 13:20:26 GMT

Must be direct access, change to dl=1

https://www.dropbox.com/s/pt2j6nl0gz73h4o/testpoints.csv?dl=1 or

https://dl.dropbox.com/s/pt2j6nl0gz73h4o/testpoints.csv?dl=0

topic CSV as dataset doesn't work in GeoAnalytics

CSV as dataset doesn't work

Re: CSV as dataset doesn't work