Transforming Data Based on Pattern Facet Results

After applying pattern facet to a column, you can transform data to consistently format your data.

Prerequisites

Applying Pattern Facet to ZIP

After applying pattern facet to the ZIP column, you can see that 49 rows are in the format of 9999. This format is a typo. To transform this format to the right 99999 format:

Procedure

  1. In the ZIP facet panel, click 9999.
    All the rows with dada in the 9999 format are displayed.
  2. From the ZIP column menu, click Edit cells > Transform.
    The Custom Text Transform on Column ZIP is displayed.
  3. In the Expression field, enter "0" + value, and then click OK.
    All the data in the 9999 format are transformed into the 99999 format.