Lookup

Lookup

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.

    • Related Articles

    • Lookup

      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 ...

    • Lookup for Categorical Variables

      The fuzzy lookup is based on the fuzzy logic in mathematics. It is supported only for categorical variables. Methods There are three methods for this feature: Threshold Matching: It compares the string values based on fuzzy logic and calculates a ...

    • Data Preparation

      What is Data Preparation Data preparation is the process of cleaning and transforming raw data into organized data so that it can be processed and further analyzed. In data preparation, data is reformatted, corrected, and combined so that it gets ...

    • Rubiscape Spring '23

      New Features Studio Rubiscape Desktop All your favorite Rubiscape features, functions, and powerful dashboarding capabilities are now available in Rubiscape Desktop for Windows. With a completely new setup wizard, you can now customize your ...

    • Rubiscape Autumn '22

      New Features Platform & Studio Administrator Module Revamp The release introduces a revamp of the Rubiscape Administrator module from a UI/ UX and functionality perspective. Muti tenancy Ability to create a User under multiple tenants Login A multi ...