...

• You cannot perform lookups on columns of Object or Array data type.

• A lookup essentially performs a left join between the first dataset and the second one. However, lookups are less flexible in terms of defining and editing them.

  Info
  NOTE: If column values are non-unique, the resulting dataset can be significantly larger than the original dataset.

This workflow task 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.

...