Detailed Description of Selective Matching Lookup Reader

The data source is a file containing a Selective Matching lookup table. A selective matching lookup table has the following format (it differs from a matching lookup table only by the availability of optional parameters).

Matching value

Real value 1

Opt. value 1

Opt. value 2

...

Real value 2

Opt. value 1

Opt. value 2

...

......

matching value

real value 1

opt. value 1

opt. value 2

...

real value 2

opt. value 1

opt. value 2

...

......

This data is loaded to the table as follows:

Matching value

Real value

Opt. value 1

Opt. value 2

...

matching value

real value 1

opt. value 1

opt. value 2

...

matching value

real value 2

opt. value 1

opt. value 2

...

matching value

...

...

...

...

Therefore, the Selective Matching Lookup Reader's output will be similar to the output of MatchingLookupReader with the only difference being that the output columns will also contain optional parameter columns (the list of these columns is specified by the property Columns).



Example: Example
<step className="cz.adastra.cif.tasks.io.lookup.read.SelectiveMatchingLookupReader" id="algorithm_10">
  <properties fileName="./selMatchFile.cif"
              matchingValueColumnName="matchingValue"
              realValueColumnName="realValue">
    <columns>
      <column type="STRING" name="ico"/>
    </columns>
  </properties>
</step>

iWay Software