Applying Pattern Facet to ZIP

Apply pattern facet to the ZIP column to filter out inconsistent data formats of zip code.

Procedure

  1. From the ZIP column menu, click Facet > Text pattern facet.
  2. In the ZIP facet panel, click count.
    Most of the values in the ZIP column are in the 99999 format.

    For details about how to transform the invalid zip values, see Transforming Data Based on Pattern Facet Results.