Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm trying today to regroup some areas I have on my map using GeoAggrGeometry() but have some difficulties.
I'd like my map to display the
Here is the script I imlplemented :
D_INSTITUTION :LOAD *FROM $(vPathLookUp)D_INSTITUTION.qvd](qvd);
left join (D_INSTITUTION)LOAD * INLINE [LB_TERRITORY, ZONE, ZONESCentre-Est,Auvergne-Rhône-Alpes,Z1,Centre-Est,Bourgogne-France-Compté,Z1Centre-Est,Grand-Est,Z1IdfEst,Essonne,Z2,IdfEst,Paris,Z2,IdfEst,Seine-et-Marne,Z2,IdfEst,Seine-Saint-Denis,Z2,IdfEst,Val-de-Marne,Z2,IdfOuest,Yvelines,Z3,IdfOuest,Val-d'Oise,Z3,IdfOuest,Hauts-de-Seine,Z3,Nord-Ouest,Hauts-de-France,Z4,Nord-Ouest,Bretagne,Z4,Nord-Ouest,Normandie,Z4,Nord-Ouest,Pays de la Loire,Z4,Nord-Ouest,Centre-Val de Loire,Z4,Sud-Ouest,Occitanie,Z5,Sud-Ouest,Nouvelle-Aquitaine,Z5,Sud-Est,Corse,Z6,Sud-Est,Provence-Alpes-Côte d'Azur,Z6,];
NoConcatenateMap:LOAD LB_TERRITORY, GeoAggrGeometry(ZONES) as [AggrArea]resident D_INSTITUTION Group By LB_TERRITORY;
as thus :
can someone could help me please ?