To specify the options for Table Lookup you create a rule. You can create multiple rules then specify the order in which you want to apply the rules. To create a rule, open the Table Lookup stage and click Add then complete the following fields.
Option |
Description |
---|---|
Action |
Specifies the type of action to take on the source field. One of the following:
|
On |
Specifies whether to use the entire field as the lookup term or to search the lookup table for each term in the field. One of the following:
|
Source |
Specifies the field you want to containing the term you want to look up. |
Destination |
Specifies the field to which the terms returned by the table lookup should be written. If you want to replace the value, specify the same field in the Destination field as you did in the Source field. You can also create a new field by typing the name of the field you want to create. The Destination field is not available if you select the action Identify. |
Table |
Specifies the table you want to use to find terms that match the data in your dataflow. For a list of tables that you can edit, see Table Lookup Tables. For information about creating or modifying tables, see Introduction to Lookup Tables. |
Lookup multiple word terms |
Enables multiple word searches within a given string. For example: Input String: "Major General John Smith" For multiple word searches, the search stops at the first occurrence of a match. This option is disabled when On is set to Complete field. Note: Selecting this option may adversely affect performance.
|
When table entry not found, set Destination's value to |
Specifies the value to put in the destination field if a matching term cannot be found in the lookup table. One of the following:
|