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 30 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 31 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. Go to Combine.

  2. Select the Lookup function.

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