Mix and squeeze data

Introduction to KNIME

Emilio Silvestri

Data Scientist

Data merging

    Merge tables

Introduction to KNIME

Value lookup

Employees table

Introduction to KNIME

Value lookup

Employees and salary tables

Introduction to KNIME

Value lookup

Highlight employee IDs

Introduction to KNIME

Value lookup

First employee

Introduction to KNIME

Value lookup

Matching IDs

Introduction to KNIME

Value lookup

Lookup salary

Introduction to KNIME

Value lookup

Dictionary

Introduction to KNIME

Value lookup

Dictionary table

Introduction to KNIME

Value lookup

Lookup and key columns

Introduction to KNIME

Value lookup

Missing match

Introduction to KNIME

Data aggregation

Calculations

Introduction to KNIME

Data aggregation

Squeeze orange

Introduction to KNIME

Data aggregation

Sum of salary

Introduction to KNIME

Data aggregation

Aggregation column

Introduction to KNIME

Data aggregation

Aggregation operation

Introduction to KNIME

Data aggregation

Salary by department

Introduction to KNIME

Data aggregation

Number of employees by department

Introduction to KNIME

Data aggregation

Average salary by department

Introduction to KNIME

Documentation

Path

Introduction to KNIME

Documentation

  Workflow

Introduction to KNIME

Metanodes

Metanode

Introduction to KNIME

Let's practice!

Introduction to KNIME

Preparing Video For Download...