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
Copyright © Cloud Software Group, Inc. All Rights Reserved.