The mapping between the key column and its value can come from a predefined list of key value pairs.
-
Select the Data Lookup tool in the palette, and create the action in the diagram.
-
Select the Data Flow tool, and draw a flow from the preceding step (a data input or action) to the data lookup to initialize it with the incoming data structure columns.
-
Double-click the data lookup symbol to open its property sheet, and select the Predefined mode in the Mode list. This triggers the display of the Lookup Keys tab.
-
Select the source column from which you want to draw the values to be replaced. Create the target column, which will contain the values returned by the lookup. The target column will automatically replace the source column in the Data Structure Columns tab.
-
Click the Lookup Keys tab, and enter key value pairs in the list as appropriate.
-
Click OK to save your changes and return to the diagram.