From the course: Introduction to Machine Learning with KNIME

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Merging with the Joiner node

Merging with the Joiner node - KNIME Tutorial

From the course: Introduction to Machine Learning with KNIME

Start my 1-month free trial

Merging with the Joiner node

“

- Okay, we're going to move on to a crisp DM task that is very labor intensive in a real world project. We're going to move on to integrate data, which is part of the data preparation phase. There are numerous functions within Nine to support this, but we're going to start with the joiner node. Okay, here we are in Nine and I've got two files that we're going to merge. Let's take a quick look at them. The first one is a bunch of transactions. I've got a product code, a transaction ID, a customer ID. Notice several transactions from the first customer here. Many transactions from the second customer. It looks like I've got a time stamp, but one of the things that I don't have, I have what they've paid, but I don't really know what they bought. I have a product code, but I don't have any explanation of the product or what type of product it is. Let's now take a look at the other one. Okay, here's the second file. Taking a look at that, we can see the product codes, much smaller table of…

Contents