Faceting to Check Duplications

Use the data faceting function to check duplicates in a column.

This example shows how to use the faceting function to check duplicates in the PATNO column.

Procedure

  1. From the PATNO column menu, click Facet > Text Facet.
  2. In the PATNO facet panel, click count.
    In the PATNO column, the values 002, 003, and 006 have duplicates.