Detailed Description of Table Matching

Implements a two-step search step for rows in an indexed table. In the first step, rows with a key matching input value (or nullFallbackName in case the input is null) are searched. If no rows are found, a second search attempt is made with the value of notFoundName as a key (notFoundName must not be null).


Top of page

Example: Example
<step id='tableMatching' className='cz.adastra.cif.tasks.clean.TableMatchingAlgorithm'>
        <properties>
                <foreignKeyColumn>key</foreignKeyColumn>
                <nullFallbackName>unknown</nullFallbackName>
                <notFoundName>default</notFoundName>
                <columns>
                        <column name="out_id" tableColumn="id" />
                        <column name="out_data" tableColumn="data" />
                </columns>
                <indexTableFileName>indexed_table.cif</indexTableFileName>
                <scorer scoreColumn='tba_score' explanationColumn='tba_expl'>
                        <scoringEntries>
                                <scoringEntry key='TBL_NO_ID' score='100' explain='true' />
                                <scoringEntry key='TBL_NOT_FOUND' score='200' explain='true' />
                                <scoringEntry key='TBL_FOUND' score='300' explain='true' />
                                <scoringEntry key='TBL_SAFE_FOUND' score='500' explain='false' />
                        </scoringEntries>
                </scorer>
        </properties>
</step>

iWay Software