Returns the ISBA TV region as derived from the postcode
GETISBA ( <field_name or postal_code> )
-
field_name or postal_code: The geographic field to extract the ISBA region from.
The codes returned are as follows:
| Code | ISBA Region |
|---|---|
| 1 | Border |
| 2 | Central Scotland |
| 3 | East England |
| 4 | Lancashire |
| 5 | London |
| 6 | Midlands |
| 7 | North East |
| 8 | North Scotland |
| 9 | Southern |
| 10 | South West |
| 11 | Wales and West |
| 12 | Yorkshire |
| 13 | Northern Ireland |
Unmatched records return a value of 0.
Example: Create a field at the HOUSEHOLD level that returns the ISBA region for each record.
GETISBA([HOUSEHOLD.POSTCODE] )