Search modes for Index rules
One type of the advanced rules used by the tStandardizeRow component is Index rules. Index rules use
synonym indexes as a reference to search for match data.
Using an Index rule without
having the possibility to specify what type of match (exact, partial, fuzzy, etc.) you
want to use on the input flow will not standardize and output the data you expect.
tStandardizeRow allows you to select one of
the following search modes for each Index rule
you define in the component:
|
Search mode |
Description |
|---|---|
|
Match all |
each word of the input string must exist in the |
|
Match all fuzzy |
each word of the input string must match similar |
|
Match any |
the input string should have at least one word that |
|
Match any fuzzy |
the input string should have at least one word that |
|
Match exact |
the exact input string should match the exact index |
|
Match partial |
each word of the input string must exist in the |
|
1 |
DULUX PAINTPOD EXTRA REACH HANDLE |
And you have created a color index that has the Extra Deep Base string.
If you define an Index rule in
tStandardizeRow and set the search mode to
Match any, the component will return Extra Deep Base as a color for the above record because there is the Extra word that matches the index string. But if you want the
component to only return a match when the exact search string is found in the index, you
set the search mode of the rule to Match exact and the component
will not return a color for the record.
For a Job example, see Scenario 3: Extracting exact match by using Index rules.