Transforming Data Based on Pattern Facet Results

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

After applying pattern facet to the ZIP column, as described in Applying Pattern Facet to ZIP, 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

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