Migrating the DatabaseLookup to AgConcat

Now that you have successfully configured tHMap, Talend Data Mapper automatically generates a new map with multiple records that represent the database input connections.

1. Select tHMap to show the Input Map and Output XML panes. See that the Input pane contains the imported database tables:

   

2. Use the AgConcat function to replace the DatabaseLookup function:
   1. Drag the row2 from the Input (Map) column to the AgConcat expression.
   2. Set SimpleLoop on the Loop Expression.
   3. Use the same filter values. If you have specified filter values in your Job using the DatabaseLookup function, re-use these filter values.