Solved: Geo-Operations in SaaS environment - Qlik Community

Wizards · ‎2020-10-21

I am having problems applying this operation dissolve in the SaaS environment .

To my knowledge the autogenerated script from geoanalytic can be migrated to geo-Operations in SaaS environment.

After several steps followed from script conversion

I am still unable to migrate my script syntax.

Jonas_Karlsson · ‎2020-10-23

This will load the data correct:

Load * Extension GeoOperations.ScriptEval ('Load() DATASOURCE NiscodeArea CSV url="https://dl.dropbox.com/s/ehw7aghq8a7k5fm/NiscodeArea.csv?dl=1", fieldSeparator="COMMA", keyField="Niscode", geometryField="RefgemG10.Area",geometryType="POLYGON", stringQuotes="DOUBLEQUOTE"');

View solution in original post

Jonas_Karlsson · ‎2020-10-23

// Faking BasisRegio since it wasnt included in the dataload *, left(Niscode,1) as BasisRegio;
Basis:
Load * Extension GeoOperations.ScriptEval('
load()
DATASOURCE dis CSV 
  	url="https://dl.dropbox.com/s/ehw7aghq8a7k5fm/NiscodeArea.csv?dl=0", 
    fieldSeparator="COMMA",
    keyField="Niscode",
    stringQuotes="DOUBLEQUOTE"
');Load * Extension GeoOperations.ScriptEval('
Dissolve(dissolveField="BasisRegio", resolution="auto", areaDatasetKeyField="Niscode", dissolveDataset="DissolveDef")
DATASOURCE DissolveDef INTABLE keyField="Niscode"
DATASOURCE NiscodeArea CSV
url="https://dl.dropbox.com/s/ehw7aghq8a7k5fm/NiscodeArea.csv?dl=0",
	fieldSeparator="COMMA",
	keyField="Niscode" ,
	geometryField="RefgemG10.Area" ,
	geometryType="POLYGON",
	stringQuotes="DOUBLEQUOTE"
', Basis);

View solution in original post

Wizards · ‎2020-10-21

Just to add and be specific. I uploaded the autogenerated script from Geoanalytics and my trial script to be used for SaaS environment which gives an error.

Patric_Nordstrom · ‎2020-10-22

The problem here is that GeoOperations can only use one internal table, it's a limitation of SSE.

See here for a workaround for placing one of the tables in a csv file. This is for closest but works in the same way for dissolve.

https://community.qlik.com/t5/Qlik-GeoAnalytics-Discussions/GeoOperations-use-CLOSEST-with-two-loade...

Thanks,

Patric

Wizards · ‎2020-10-23

Thank you for the responds @Patric_Nordstrom

I followed the steps as for the example provided. Using this script

Load * Extension GeoOperations.ScriptEval('
Dissolve(dissolveField="BasisRegio", resolution="auto", areaDatasetKeyField="Niscode", dissolveDataset="DissolveDef")
DATASOURCE DissolveDef INTABLE keyField="Niscode", namedAreaField="BasisRegio"
DATASOURCE NiscodeArea CSV
url="https://www.dropbox.com/s/l43doha3qziij5j/NiscodeArea.csv?dl=0",
    fieldSeparator="TAB",
    keyField="Niscode" ,
    geometryField="RefgemG10.Area" ,
    geometryType="POLYGON"
', Basis);

I get an error saying unknown geometry field

Patric_Nordstrom · ‎2020-10-23

The dropbox link needs to be direct file access

url="https://dl.dropbox.com...

Wizards · ‎2020-10-23

Thanks for the heads up. Unfortunately its still giving the same error (Unknown geometry field in CSV, RefgemG10.Area') after giving a direct acces to the Dropbox.

Load * Extension GeoOperations.ScriptEval('
Dissolve(dissolveField="BasisRegio", resolution="auto", areaDatasetKeyField="Niscode", dissolveDataset="DissolveDef")
DATASOURCE DissolveDef INTABLE keyField="Niscode", namedAreaField="BasisRegio"
DATASOURCE NiscodeArea CSV
url="https://dl.dropbox.com/s/ehw7aghq8a7k5fm/NiscodeArea.csv?dl=0",
fieldSeparator="TAB",
keyField="Niscode" ,
geometryField="RefgemG10.Area" ,
geometryType="POLYGON"
', Basis);

Jonas_Karlsson · ‎2020-10-23

Hi,

Try to use ...?dl=1
instead of ...?dl=0
in the Dropbox link.

Cheers

/Jonas

Wizards · ‎2020-10-23

Hi @Jonas_Karlsson

I tried both as well earlier on how to get direct-link to files in Dropbox.

same error

Jonas_Karlsson · ‎2020-10-23

Maybe

~~fieldSeparator="COMMA",~~

Use TAB

/J

Wizards · ‎2020-10-23

hi @Jonas_Karlsson

That too was done but I return this error