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.
- Type: TableData TableThe data table has a column that contains lookup values
- Type: TableDictionary TableThe dictionary table has a key column and value columns that will be inserted into the data table