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.

When you assign a wrong data type to a column, or your data is invalid, an invalid icon is displayed in front of the invalid row. In such cases, the column analysis will not be displayed on the "Profiling analysis" page.

Procedure

  1. On the project data page, click .
  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.