# Lookup table

> Looks a field's value up in a table of rows.

A row gives a value (saved as flow.lookup), or assigns the lead to a queue's next rep or a named rep.

| | |
|---|---|
| Type | `lookupTable` |
| Group | Data |

## Exits

| Exit | Name |
|---|---|
| `found` | Found |
| `notFound` | Not in table |

## Settings

| Key | Label | Takes | Default | Notes |
|---|---|---|---|---|
| `field` | Look up the value of | A string. |  | A field, such as form.country or sopro.country. |
| `gives` | A row gives | `value` A value, as flow.lookup, `queue` The next rep of a queue, `rep` A named rep | `value` |  |
| `rows` | Rows | An array of objects, each {"key": the value to match (several separated by \|), "value": what the row gives: text, a queue's id or a rep's id, as the step's 'gives' setting says}. |  | The first row whose key is the field's value is used, whatever its case. Several keys in one row: separate them with \|. |

## Fields it adds

| Field | What |
|---|---|
| `flow.lookup` | What the lookup table gave |

## In a flow document

```json
{
  "id": "lookupTable1",
  "type": "lookupTable",
  "settings": {
    "gives": "value"
  }
}
```