...
Stored Procedure at_wkf_geopivot_sum
This counts of all records for each distinct entry in a category column from one table for each area in another table.
at_wkf_geopivot_sum takes the following parameters:
...
at_sys_geopivot_sum finished: table [output_table] created
The resulting table in this scenario looks like this:
Once the table has been created this can be added as a Layer in Studio e.g.
...
Stored Procedure at_wkf_geopivot_count
This counts of all records for each distinct entry in a category column from one table for each area in another table.
at_wkf_geopivot_count takes the following parameters:
...