Indicator parameters - 6.2

Talend Data Management Platform Studio User Guide

EnrichVersion
6.2
EnrichProdName
Talend Data Management Platform
task
Data Quality and Preparation
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.