From the course: Low Code/No-Code Data Literacy with KNIME: From Basic to Advanced
Join today to access over 24,800 courses taught by industry experts.
Data merging with KNIME: Value lookup - KNIME Tutorial
From the course: Low Code/No-Code Data Literacy with KNIME: From Basic to Advanced
Data merging with KNIME: Value lookup
(slow melodic music) - In this video, you will learn how to perform value lookup in analytics platform. Let's get started. Value lookup is an operation that lets you append values from a dictionary table to a data table according to a matching column. In the data table, you have the order number and the store ID. In a second table, the dictionary table, you have for each store ID, the information whether the store is an online or onsite store. You can use the value lookup node to bring to the data table the information about the store type from the dictionary table according to the matching store ID. Let's see how to perform the value lookup operation in an analytics platform. You have to provide the data table and the dictionary table as input of the value lookup node. In this example, the data table contains the orders and the dictionary table contains the information about the stores. In the configuration window, select the two columns that have to match. In this case, the column…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.