The mapping between the key column and its value can come from database tables.
-
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 Database mode in the Mode list. This triggers the display of the Script 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 Script tab, select a data connection, and specify a SQL query in the textbox. The query will be executed against the database tables and will return two columns (a key column to search for a corresponding value and a value column to store the corresponding value).
-
Click OK to save your changes and return to the diagram.