Applying Pattern Facet to SSN

Apply pattern facet to the SSN column to filter out inconsistent data formats of social security number.

Procedure

  1. From the SSN column menu, click Facet > Text pattern facet.
  2. In the SSN facet panel, click count.
    Most of the values in the SSN column are in the 999-99-9999 format.