Welcome to Module 2

In this lesson, we're going to have an outlook what you can expect in Module 2. We will go through our Course Map so you have a clear understanding of the content you're going to discover.

What we’re going to build in Module 2

In this lesson you will get a short overview of what you will build from scratch. We create a list of prioritiy suppliers for which we want to improve the payment terms. We have the task to start with the highest financial impact first so we let KNIME do the heavy lifting to determine who this is. We also share our basefiles and a very brief overview of the workflow you will build.

ETL & why micro steps are a good thing

In this lesson you will learn what ETL is, how it relates to KNIME and why micro steps - as in KNIME - are a good thing for many reasons.

KNIME Visual Language Pt 1 (Node Colors)

In this first part of the KNIME Visual Language we cover what the different node colors mean. We will also meet the term "ETL" from the last lesson again.

KNIME Visual Language Pt 2 (Traffic Lights & Ports)

In this second part you will learn what those traffic lights mean, that come with every node. We will also discuss the most common in- and outports of the nodes.

Workflow Annotations (and a little trick)

In this video, we will discover what Workflow Annotations are and how we can use them to structure our automations.

Name your nodes!

In this lesson we discuss why it is crucial to name your nodes.

Right-click to get results

This lesson covers how we quickly can see the results of each node and how to find out the table specs.

Excel Reader Node

In these first nodes of the workflow, you're going to load the base reporting file into KNIME.

Filters Pt 1 (Row Filters)

Filters are an important feature of KNIME. In this lesson you are going to learn how to apply them to delete rows that are unnecessary for the final result.

Joiner Node

Here we join two different tables together. You also will discover what different types of "joins" are available in KNIME. We use the Joiner Node to add "rich data" to our data table (in this example the Payment Terms descriptions).

String Manipulation Node

We often have to work with text in data tables. This lessons helps you to learn how you can concatenate two different string fields.

Filters Pt 2 (Column Filters)

In this second lessond on filters, you are going to filter out the columns that are not relevant for the required result.

Column Resorter Node

In this lesson you discover how you can rearrange the structure of the data table in a way that makes more sense.

Excel Writer Node

Let's write the information we have so far for documentation purposes into a spreadsheet file. We will also cover an additional feature (very helpful!) of the Excel Reader Node later in this chapter.

Rule Engine Node

The Rule Engine Node of KNIME is the equivalent of MS Excel's "IF" formulas (on steroids). Discover how you can use it to "rule out" data that we no longer need.