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: How to join two tables - KNIME Tutorial
From the course: Low Code/No-Code Data Literacy with KNIME: From Basic to Advanced
Data merging with KNIME: How to join two tables
(lively music) - In this video, you will learn how to join two tables in KNIME Analytics Platform, how to configure the joiner node for the different join modes, and finally, the differences between the value lookup and the joiner node. Let's have a look. The joiner node has two input ports, the upper port for the left table and the bottom port for the right table. In this example, the left table contains order and the relative store, and the right table contains information about each store. The column containing the StoreIDs is present in both tables. However, both table contains some StoreIDs that is not present in the other table. Open the configuration of the joiner node. First, you have to provide the columns on which you want to join. In this case, provide the column containing the StoreID in the left and right tables. You can add more joining columns by clicking the plus button. Rows from the left and the right tables are matched based on the values in these columns. If you…
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.