Lookup: table

Still only in beta available

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:

By selecting "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.

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
Lookup table file	The table to use for the lookup	Select the lookup table from the contents section, see screenshot above.
Fuzzy matching	Exact or fuzzy match	Whether the best possible match, or the exact match should be returned
Variable to match	Variable to match in the table	In which variable is the information to look for? (like a name or department)
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)