DISTRICTLABEL

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

DISTRICTLABEL ( <field_name or postal_code> )
  • field_name or postal_code: The geographic field to extract the area section from.

Example: Create a field at the HOUSEHOLD level that returns the postal district section of the postcode.

DISTRICTLABEL ( [HOUSEHOLD.POSTCODE] )