Skip to main content

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

cancel
Showing results for 
Search instead for 
Did you mean: 
hqx
Employee
Employee

GeoAnalytics Dataset

Hi Team,

My customer required to connect to Google Bigquery to load the Geo Data using Load data editor but failed. I realized that the dataset seems wrong with additional data and using curve "(" bracket instead of  square "[" bracket but I am not sure whether I am correct and need some help on this.

The following are part of the data provided and please let me know how to correct it if the Geo data is incorrect.

 hqx_0-1656291591273.png

hqx_1-1656291689358.png

If you need the actual data for further investigation, please do let me know and I will send it to you.

Thank you very much and have a nice day!

Best regards,

James Wong

Labels (2)
1 Reply
Patric_Nordstrom
Employee
Employee

 

This is wkt, which GeoOperations reads natively, just use the load operation:

Note that the geometry field needs to be renamed.

regions:
LOAD
region,
geometry as region_geom_wkt
FROM [lib://Patrics Share:DataFiles/region_geo_simplify.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);


region_poly:
Load * Extension
GeoOperations.ScriptEval(
'Select region, region_geom_wkt as region_poly from Load()
', regions);