Indicator parameters - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

This section describes indicator parameters displayed in the different Indicators Settings dialog boxes.

Bins Designer

Possible value Description
Minimal value Beginning of the first bin.
Maximal value End of the last bin.
Number of bins Number of bins.

Blank Options

Possible value Description
Aggregate nulls with blanks When selected, null data is counted as zero length text field. This means that null data is treated as an empty string. When not selected, null data is treated as any other text data.
Aggregate blanks When selected, blank texts (e.g. " ") are all grouped together and considered as an empty string. When not selected, blank texts are treated as any other text data.
Note: In Oracle, empty strings and null strings are the same objects. Therefore, you must select or clear both check boxes in order to get consistent results.

Data Thresholds

Possible value Description
Lower threshold Data smaller than this value should not exist.
Upper threshold Data greater than this value should not exist.

Value Frequency Parameters

Possible value Description
Number of results shown Number of displayed results.

Indicator Thresholds

Possible value Description
Lower threshold Lower threshold of matching indicator values.
Upper threshold Higher threshold of matching indicator values.
Lower threshold(%) Lower threshold of matching indicator values in percentage relative to the total row count.
Upper threshold(%) Higher threshold of matching indicator values in percentage relative to the total row count.
Expected value Only for the Mode indicator in the Advanced Statistics. Most probable value that should exist in the selected column.

Java Options

Possible value Description
Characters to replace List of the characters to be replaced.
Replacement characters List of the characters that will take the place of the replaced characters.
Note: Each character of the first field will be replaced by the character at the same position from the second field. For example, with the values "abc0123ABC,;.:" in the first field and "aaa9999AAApppp" in the second field any "a", "b" or "c" will be replaced by "a" and any "0", "1", "2" or "3" will be replaced by "9".

Phone number

Possible value Description
Country Country ISO2 code of the phone number.

Text Parameters

Possible value Description
Ignore case When selected, comparison of text data is not case sensitive.

Text Length

Possible value Description
Count nulls When selected, null data is counted as zero length text field.
Count blanks When selected, blank texts (e.g. " ") are counted as zero length text fields.