Lookup
Look up matching values in multiple selected columns in two data sets.
Look up matching values in multiple selected columns in two data sets. When the Lookup tool finds a match, the tool adds the values as new column(s) which appear in the output. The tool takes the lower value when there are multiple matches.
Input and output
To use this tool, you will need two sets of data, a main data set and a lookup data set. There are three fields to configure for the input:
The first field is the Top match column, which is the main data set.
The second field is the Bottom match column, which is the lookup data set.
The third field is the Column(s) to add to top, which is where you can select one or more columns from the bottom data set.
When to use this tool
Use when you want to look for a specified value in your data set.
Usage example
You want to match the Region code in the top and bottom data sets, and add the corresponding Chair of board and Number of schools columns. Here is an example of the top and bottom data sets and the output:
Region | Region code | Number of students | Number of teachers |
|---|---|---|---|
School board A | 000 | 999,999 | 150 |
School board B | 111 | 111,111 | 50 |
School board C | 2222 | 222,222 | 75 |
Region code | Chair of Board | Number of schools |
|---|---|---|
000 | Audrey Peters | 150 |
111 | Luz Reyes | 100 |
2222 | Simon Green | 50 |
000 | Audrey Peters | 100 |
Here is the output from the Lookup tool:
Region | Region code | Number of students | Number of teachers | Chair of Board | Number of schools |
|---|---|---|---|---|---|
School board A | 000 | 999,999 | 150 | Audrey Peters | 100 |
School board B | 111 | 111,111 | 50 | Luz Reyes | 100 |
School board C | 2222 | 222,222 | 75 | Simon Green | 50 |