JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page. Applying Pattern Facet to ZIP Apply pattern facet to the ZIP column to filter out inconsistent data formats of zip code. Procedure From the ZIP column menu, click Facet > Text pattern facet. 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. Copyright © Cloud Software Group, Inc. All rights reserved.