# Lookup: Table

{% hint style="info" %}
Still only in beta available
{% endhint %}

The lookup table node variant is used to do a quick lookup of a value in a lookup table that can be maintained by the user in the Contents section.

This is particularly useful for searching the phone number that corresponds to for instance a name or a department.

The flow node is typically used in a setup like this:

<figure><img src="https://3356808761-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEBQHGJABNTj5ISSOTRxM%2Fuploads%2FoKn9Y9jqolO0l8dzxLmr%2Fimage.png?alt=media&#x26;token=a7b62bc3-b856-45f2-87e8-33ce1b02ff1f" alt=""><figcaption></figcaption></figure>

By selecting "apply fuzzy matching" the system will try to find the best matching row, whereas, when untoggled, the system will find the "exactly matching" row.

### Managing lookup tables

The look up tables can be managed in the contents section of the platform.

Using the + icon a new table can be added.

<figure><img src="https://3356808761-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEBQHGJABNTj5ISSOTRxM%2Fuploads%2FafMlgWG22RbEraHul4l1%2Fimage.png?alt=media&#x26;token=7690a5a6-753f-49bd-8c44-965dadb1f843" alt=""><figcaption></figcaption></figure>

By clicking on the table name, its contents can be edited, as shown in the example above, the "Names" table is selected.

The tables will always be of the same shape holding two columns: `match` and `result`.

The `match` column is used as the value to look for, and the `result` column is used as output.

### Node properties

| Property             | Description                                    | Explanation                                                                                                 |
| -------------------- | ---------------------------------------------- | ----------------------------------------------------------------------------------------------------------- |
| Match                | Variable to match in the table                 | In which variable is the information to look for? (like a name or department)                               |
| In lookup table      | The table to use for the lookup                | Select the lookup table from the contents section, see screenshot above.                                    |
| Variable for result  | Variable to store the result from the table in | In which variable do you want to store the result? (result column in the lookup table; like a phone number) |
| Apply fuzzy matching | Exact or fuzzy match                           | Whether the best possible match, or the exact match should be returned                                      |
