Lookup | |||
Description | Lookup helps you to match values of specified fields in two data sources. | ||
Why to use | To compare values in data sources. | ||
When to use | To determine the presence of a particular field from one data source in another data source. | When not to use | When the data sources do not contain any common fields. |
Prerequisites | No prerequisites; it can be applied to any data source. | ||
Input | Two data sources containing one or more common fields. | Output | Based on the option selected for the If non matching records found? property, matching/non-matching records are returned, or task fails. |
Statistical Methods used | — | Limitations | No limitations; it can be applied to any data. |
Lookup checks all the values in the given data sources and matches the records from one data source to another for the selected fields.
Lookup is not a stand-alone activity; it is to be connected to a predecessor. The predecessor can be a dataset or output obtained from any data pre-processing node. In the Lookup properties, you can specify the dataset to which you want to compare the values of the predecessor of Lookup.