Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next


  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.