{"title":"Value Lookup","nodeType":"Manipulator","id":"*S2w-f2z3562iiLac","factoryName":"org.knime.base.node.preproc.valuelookup.ValueLookupNodeFactory","factoryId":"org.knime.base.node.preproc.valuelookup.ValueLookupNodeFactory","path":["Manipulation","Column","Split & Combine"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"

The node has two inputs: a data table and a dictionary table.\n
\n From the data table select the column that is used to look up values in the dictionary table.\n
\n From the dictionary table select a column that contains the search keys or criteria.\n
\n 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.\n
\n 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.\n
\n
\n In the output section you can select the columns in the dictionary table that shall be inserted in the output data table.

\n ","shortDescription":"Uses a dictionary table to look up values and append the corresponding cells to a row.","keywords":["Cell replacer","dictionary"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Split & Combine","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAACBSURBVHgBxZKBCcAgDAQTcRVdxqHUoZzPNgrShFgUoT2IwqOveYIAUOEAS0ut3AMRlzUDh3xnIL+/ZZBzbjv1/CzCrryWUup6CEzHUgD7+TpeeCN5D9E5ZrAVopaDkQe0ImKM7QcTY47U7stDl8UyGL0pU6exNYmzgP8f5ZYBHHABScBlsHhHpdwAAAAASUVORK5CYII=","sinceVersion":"5.0.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data Table","description":"The data table has a column that contains lookup values"},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Dictionary Table","description":"The dictionary table has a key column and value columns that will be inserted into the data table"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data Table with additional columns","description":"The output table is the data table but with the added values from the dictionary table"}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Lookup column (data table)","description":"The column in the data table that will be used to look up cells in the dictionary.","optional":false},{"name":"Key column (dictionary table)","description":"The column in the dictionary table that contains the search key / criterion.","optional":false},{"name":"If multiple rows match","description":"Defines the behavior in case there are multiple matching keys in the dictionary table.","optional":false},{"name":"If no row matches","description":"Defines what happens when a lookup key is not present in the dictionary: If "Insert missing values" is selected, missing values are inserted. If "Match next smaller" ("- larger") is selected, the next smaller (larger) value from the dictionary is matched, based on the value of the lookup key. If no such element can be found, a missing value is inserted.","optional":false},{"name":"String matching","description":"The matching behavior when matching strings: Full string matching matches a lookup string only if it exactly matches a search string. Substring matching matches a lookup string if the key in the dictionary is a substring of it. Wildcard and Regex matching match a lookup string if a pattern in the dictionary matches it.","optional":false},{"name":"Match strings case-sensitive","description":"When enabled, the string matching will be case-sensitive, otherwise case-insensitive.","optional":false},{"name":"Lookup column output","description":"Defines the content of the column that is selected as lookup column (data table). If "Retain" the content of the lookup column is left unchanged. If "Replace" is selected, the cell contents are replaced with values from the dictionary table. If a match is found, the selected column's value is inserted, otherwise the original value can be kept or a missing value can be inserted. The name of the column does not change. If "Delete" is selected, the lookup column is removed entirely from the output table.","optional":false},{"name":"Replacement column","description":"The column from the dictionary table that provides the new values for the lookup column in the data table.","optional":false},{"name":"If no match found","description":"Defines the content of the lookup column if no match is found in the dictionary table. If "Retain" is selected, the cell is left as is. If "Insert missing" is selected, a missing value is used as content for the cell in the lookup column.","optional":false},{"name":"Append columns (from dictionary table)","description":"The columns in the dictionary table that contain the values added to the data table.","optional":false},{"name":"Append a column indicating whether a match was found","description":"When checked, a new column "Match Found" is appended to the output that contains a boolean indicating whether a match was found.","optional":false},{"name":"Enable hiliting","description":"Enable hiliting between the dictionary table and the output table.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}