Page tree

Versions Compared

Key

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

D toc
You

Excerpt

Through the Transformer page, you can perform lookups from one set of values in your dataset into another set of values in another dataset using a simple wizard. To perform a lookup, select the caret next to a column title, and then select Lookup....

lookup compares each value in the selected column against the values in a selected column of the target dataset. Where a match is found, the values in other columns of the target dataset are inserted as new columns in the dataset from which the lookup was executed. 

...

This workflow is best demonstrated by example. In this case, your raw sales data records product information in internal numeric identifiers. For analysis, you may want to integrate data from your products master data based on the internal identifier, so that you have a product description and other useful information as part of your dataset.To perform a lookup, select the caret next to a column title, and then select Lookup....

Lookup Wizard - Step 1

In the first step, you select the dataset against which you would like to perform your lookup for matching data for the Item_Nbr column. In this example, the products dataset is selected, since it contains the list of recognized products:

...