Lookup

The Lookup task allows populating of additional information about entries in a column from another reference view.

This task is very similar to the Join or Merge task supported by Mammoth. The key difference is that Lookup brings only one column from the reference view while Join can bring multiple columns from the reference view.

This task is similar to doing a VLOOKUP in Microsoft Excel.

Table of Contents

Quick Start

Let us start with the following sample data:

Table 2 Mark Sheet → View 1
Student ID Total Marks
2 239
1 232
4 200

The data is a collection of Student IDs. Let us also assume that we have a reference view containing the following data:

Table 3 Students → View 1
ID Name
1 Alice
2 Bob
3 Chuck
4 Diana

Let us assume that you want to populate the Mark Sheet with the Student Name. You can achieve that by completing the following steps:

  1. Open Data Preparation menu and click on Merge & Branch Out
  2. Select Lookup
  3. Select Student ID as the Key Column.
  4. Select Students → View 1 as the Lookup Table.
  5. Under the Lookup Table, Select ID as the Key Column, Name as the value column.
  6. Enter Name as the new column name.
  7. Click APPLY.

The final result will appear as shown below:

Table 4 Mark Sheet → View 1
Student ID Total Marks Name
2 239 Bob
1 232 Alice
4 200 Diana

Supported Options

  • Source Key Column: The column used as the key when performing Lookup.
  • Lookup Table: The view used as the reference table when performing Lookup.
  • Lookup Key Column: The column in the reference table used as the key when performing Lookup.
  • Lookup Value Column: The column in the reference table used as the value when performing Lookup.
  • Apply result into: This option allows configuration of the destination of the results by this task. See result documentation.

See also

Result Column

The result column documentation

Number Formatting

The numeric formatter documentation