...

1. In the Transformer page, click the drop-down on the column that contains your two-letter state abbreviations. Select Lookup ....
2. In the Lookup Wizard, select the dataset to use for your lookup.
3. For the lookup key, select the column in the dataset to use as the key value. In the above example, it is State_2Letter.
4. Click Execute Lookup.
5. The lookup key value is used to locate all of the other column values in the reference dataset. These values are inserted in separate columns to the immediate right of the source column.
6. You might need to drop delete some of the imported columns. In the above case, you might decide to drop delete the two-letter state identifier column, which has been replaced by the full state name column.

...