Inserting a Data Lookup

A data lookup lets you find the corresponding value to a key column, and replace it by creating a new column for the output data flow. The mapping between the key column and its value can come from database tables or from a predefined list of key value pairs.

1. Select the Data Lookup tool in the Toolbox, and create the action in the diagram.
2. 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.
3. Double-click the data lookup symbol to open its property sheet, and select one of the following modes:

   • Database mode - 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).

     
     
     

   • Predefined mode - 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.

     
     
     
4. Click OK to save your changes and return to the diagram.