Table Details in Profiling Results
- 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
- 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.