SECTORLABEL

This function will extract the sector label from a postcode in standard UK format.

SECTORLABEL ( <field_name or postal_code> )

  • field_name or postal_code: The geographic field to extract the sector section from.

Example: create a field at the HOUSEHOLD level that returns the postal sector section of the postcode.

SECTORLABEL( [HOUSEHOLD.POSTCODE] )