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, ZONES
Centre-Est,Auvergne-Rhône-Alpes,Z1,
Centre-Est,Bourgogne-France-Compté,Z1
Centre-Est,Grand-Est,Z1
IdfEst,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,
];
NoConcatenate
Map:
LOAD LB_TERRITORY,
GeoAggrGeometry(ZONES) as [AggrArea]
resident D_INSTITUTION Group By LB_TERRITORY;
as thus :
can someone could help me please ?
www.easyneo.fr