Simple statistics - Cloud

Talend Cloud Data Management Platform Studio User Guide

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Talend Management Console
Talend Studio
Content
Design and Development

They provide simple statistics on the number of records falling in certain categories including the number of rows, the number of null values, the number of distinct and unique values, the number of duplicates, or the number of blank fields.

  • Blank Count: counts the number of blank rows. A "blank" is a non null textual data that contains only white space. Note that Oracle does not distinguish between the empty string and the null value.

    The LONG VARCHAR data type in Vertica is not supported.

  • Default Value Count: counts the number of default values.
  • Distinct Count: counts the number of distinct values of your column.
  • Duplicate Count: counts the number of values appearing more than once. You have the relation: Duplicate count + Unique count = Distinct count. For example, a,a,a,a,b,b,c,d,e => 9 values, 5 distinct values, 3 unique values, 2 duplicate values.
  • Null Count: counts the number of null rows.
  • Row Count: counts the number of rows.
  • Unique Count: counts the number of distinct values with only one occurrence. It is necessarily less or equal to Distinct counts.

The following table shows the indicators that you can select in any database:

Data type Number Text Date Others
Analysis engine type Java SQL Java SQL Java SQL Java SQL
Row Count
Null Count
Distinct Count
Unique Count
Duplicate Count
Blank Count
Default Value Count * * * * * * * *
*Only when the database table has a default value constraint