The Value tab - Cloud

Talend Cloud Data Preparation User Guide

Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Data Preparation
Content
Administration and Monitoring > Managing connections
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Managing datasets
Last publication date
2023-09-13

The Value tab displays various summary statistics for the selected column. Those statistics are only available for columns with numeric values.

  • Count: Number of values in the column
  • Distinct: Number of different values in the column
  • Duplicate: Number of identical values in the column
  • Valid: Number of valid values in the column
  • Empty: Number of empty records in the column
  • Invalid: Number of invalid values in the column
  • Avg length: Average length of the string values based on the number of characters in the column records
  • Min length: Minimum length of the string values based on the number of characters in the column records
  • Max length: Maximum length of the string values based on the number of characters in the column records
  • Min: The lowest value of the column
  • Max: The highest value of the column
  • Mean: The average value of the column
  • Variance: The distribution of the values compared to the mean value. Mathematically defined as the average of the squared differences from the mean value.