Replacement by Exact Match

The Value field of the replacement table contains the values to be replaced. The algorithm searches for exact match of the source data with the values of this field. If such match is found, it is replaced with the value of the Replace field.

The algorithm logics example:

The source data value Values of the replacement table rows Match New value

"Replace" field

"Value field"
48 12 Poor No Excellent
24 Satisfactory No
36 Good No
48 Excellent Yes
60 Perfect No

Data use example:

Replacement Table

Replacement Value
12 Poor
24 Satisfactory
36 Good
48 Excellent
60 Perfect

Result of the performed replacement

Source data value New value
12 Poor
15 15
24 Satisfactory
35 35
48 Excellent
73 73

As shown in the table of comparison of the source data with the final one, all data not included into the Replacement table is not replaced and it is shown in the source form. The values not included into the Replacement table are processed according to the specified Precision and Replace other parameter.

Use of the Allowable Interval

It is possible to specify the allowable search interval when searching for real and integer data. Precision parameter is required for its configuration. Intervals are calculated as follows: from <Replace field value>-<Precision> to <Replace field value>+<Precision>. If several matches are found taking into account the interval, the closest match to the source one will be used.

The algorithm logics example with interval use:

The source data value Values of the replacement table rows Allowable interval Match interval Match The closest to source New value

"Replace" field

"Value field"
50 12 Poor 20 from -8 to 32 No No Excellent
24 Satisfactory from 4 to 44 No No
36 Good from 16 to 56 Yes No
48 Excellent from 28 to 68 Yes Yes
60 Perfect from 40 to 80 Yes No

Data use example:

Replacement Table

Replacement Value
12 Poor
24 Satisfactory
36 Good
48 Excellent
60 Perfect

Precision is equal to 12.

Result of the performed replacement

Source data value New value
12 Poor
15 Poor
24 Satisfactory
35 Good
48 Excellent
73 73

The values included neither into the Replacement table, nor into Allowable intervals, are processed according to the configured parameter - Replace other.

results matching ""

    No results matching ""