Faceting to Check Invalid Values Use the data faceting function to check invalid values in a column. This example shows how to use the faceting function to check duplicates in the GENDER column. Procedure From the GENDER column menu, click Facet > Text Facet. In the GENDER facet panel, click count. The GENDER column has invalid values:2, X, and (blank). Copyright © Cloud Software Group, Inc. All Rights Reserved.