Qlik Geo Analytics - Dissolve Area using the Postcal code data [UK]

[kishore3k]

Hi everyone,

I'm working on a project that involves dissolving areas based on UK postcodes. I've been following the official guide, but I keep encountering an error message that says "unknown column in dissolve table."

To help troubleshoot, I've attached a sample dataset containing "Postcode" and "Place Name" columns. Ideally, I'd like to populate polygon shapes for each place name based on the corresponding postcode.

Any advice or guidance on how to resolve the error  would be greatly appreciated. Thanks in advance for your help!

[Aurelien_Martinez]

Hi,

I can't have acces to a Geoanalytics Connector, but you can try to configure the connection like :

Dissolve field : placename
Type : Load table
Table Name : data
Table Fields : postalcode, postalcode, placename
Geometry Type : Location Named Area

Geometries to dissolve : none