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
