Transforming Files - Getting Started with Talend Open Studio for Data Integration - page 74

9. Now click on the second tab in the left-hand side window showing the
schema for the second delimited file input. Select the state_code column and
copy this over to the right-hand side window, using the top-arrow button.
10. In the right-hand side window, click on the state_code column and move it
up one place on the list of fields by clicking on the up arrow button:
11. Click on OK to save the changes, and when prompted to propagate the
schema changes, click on Yes . This will copy the tJoin schema over to the
delimited output component.
12. In the Basic settings tab of the tJoin component, click on the checkbox
Include lookup columns in output .
13. In the Column mapping box, add a row and select state_code from the
Output column drop-down menu. In the Lookup column section, select
row2.state_code .
14. In the Key definition table, add a row and select state as the Input key
attribute field, and row2.state_name as the Lookup key attribute field;