Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 

 

 

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.