Performing Column Analysis

Perform column analysis to check the content of the data within columns to find anomalies that can affect your data quality.

Note: The data profiling function does not profile the data that contains invalid values or a data column that is mismatched with its data type.

Procedure

  1. On the project data page, click Profile.
  2. From the Analysis type list, select Column analysis to generate a column analysis report.

    From this column analysis report, you can view the data status for each of your data columns. The results are grouped into three groups based on column data types: Numeric columns, Date&Time columns, and String columns.

    For more details, see Column Analysis Report.

  3. Optional: Click each item value to view the rows that match the column analysis criteria.
  4. Optional: Click Export in the upper-right corner of the page to export the analysis report.
  • Column Analysis Report
    When profiling project columns, columns are divided into three types: numeric columns, date and time columns, and string columns.