Table Details in Profiling Results

Click any of the table names in the left pane to display these details:
  • Completeness: The percentage of complete and incomplete rows detected in your profiled data
  • Table Summary: Displays these details for every column in the table
    • Column Name: Names of all the columns in the table
    • Data Type: The data type in the column
    • Completeness (%): Completeness of records in the column
    • Uniqueness : Uniqueness of the data contained in the column
    • Detected Type: Displays the semantic types, such as email, phone, city, first name, and last name detected in the string in this column.
    • Other Stats: Displays various other statistics such as Min Length, Max Length, and Text Patterns
  • Null Count Frequency: Displays the number of null values in every row of the table

Viewing Outliers

You can view a summary of the outliers detected for each column in your table by clicking the Outlier Analysis tab. This tab displays category-wise occurrences of any pattern, value, length, or frequency for a column that falls outside the range of other observations.

For example, The permissible length of Country Names is up to 14 characters and strings having 15 characters are detected in your data; this string will be categorized under Length Outlier. The supported categories are Length Outliers, Frequency Outliers, Text Pattern Outliers, Numeric Outliers, Semantic Type Outliers, and Data Type Outliers.

Viewing Malformed Records

In Flat File profiling you can view malformed records in your table by clicking the Malformed Records tab. This tab displays the Category and Count of the malformed records. A record is treated as malformed for these categories:
  • Rows with lesser number of fields than the number of defined columns
  • Rows with more number of fields than the number of defined columns

    You can also display a preview of the malformed records by clicking the Category. The preview displays the Record Number, Record, and the Reason for categorizing a record as malformed.