CDQ Data Quality as Service

Idea Portal

Adding Cleaner to Postal Code Field for BP Lookup

The postal code in NL has 4 digits and 2 letter, with a space in between (format: NNNN AA). External reference data sources maintain the postal code sometimes with and sometimes without the blank space. The BP Lookup performs an exact search for the postal code with the blank space. Adding a cleaner would allow match results to be found with and without blank space.

  • Christian Käsler
  • May 15 2023
  • Needs review
  • Attach files