Skip to main content

Symon.AI help center

Lookup

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.

lookup.png

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.

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:

Table 27. Top data set

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



Table 28. Bottom data set

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:

Table 29. Output

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