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

  1. From the GENDER column menu, click Facet > Text Facet.
  2. In the GENDER facet panel, click count.
    The GENDER column has invalid values: 2, X, and (blank).