Value Lookup

The node has two inputs: a data table and a dictionary table.
From the data table select the column that is used to look up values in the dictionary table.
From the dictionary table select a column that contains the search keys or criteria.
When a lookup value matches an entry in the dictionary, cells from that row are appended to the data table. In case multiple rows match you can choose if you want to use the first match or the last match. If no rows match you can choose to insert missing values, match the next smaller value or match the next larger value.
Missing values are treated as ordinary values, i.e. they are valid as lookup and replacement value. The key column of the dictionary can also be a collection type. Then, the values in the collection act as alternative lookup values for the associated row.

In the output section you can select the columns in the dictionary table that shall be inserted in the output data table.

Input ports

1. Type: Table
   Data Table
   The data table has a column that contains lookup values
2. Type: Table
   Dictionary Table
   The dictionary table has a key column and value columns that will be inserted into the data table

Output ports

1. Type: Table
   Data Table with additional columns
   The output table is the data table but with the added values from the dictionary table