Hi guys,
I'm trying to aggregate postcode areas to a several sales areas. This is what have in the script so far:
[MapSource]:
LOAD
"Postcode",
"Sales-Region",
FROM [----]
(ooxml, embedded labels, table is UP5);
Map:
LOAD "Sales-Region",
GeoAggrGeometry("Postcode") as [Aggr]
resident MapSource Group By "Sales-Region";
drop Table MapSource;
The table [MapSource] is looking like that:
Postcode | Sales-Region |
01067 | B1 |
01069 | B1 |
01097 | B2 |
01099 | B2 |
01108 | B3 |
01109 | B3 |
.... | .... |
Unfortunately the field [Agrr] is empty after the load.
Maybe you can help me
Thank you!
Regards
Samuel