Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Wizards
Contributor II
Contributor II

Geo-Operations in SaaS environment

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.

@Patric_Nordstrom 

 

 

Labels (1)
13 Replies
Jonas_Karlsson
Employee
Employee

Add

stringQuotes="DOUBLEQUOTE"

 

Jonas_Karlsson
Employee
Employee

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"');
Jonas_Karlsson
Employee
Employee

// 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);
Wizards
Contributor II
Contributor II
Author

Hi @Jonas_Karlsson 

I start  to see a green light, apparently the order in which the Dataset parameter are arranged plays a big role in the script run.

After  arranging the parameters my script runs successfully.

I will check the results, then after If results are as expected, I  will accept as solution.