Indicator parameters - 7.1

Talend Data Management Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Data Management Platform
task
Design and Development
EnrichPlatform
Talend Studio
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.