Data integration

Data Transformation in KNIME

Mahantesh Pattadkal

Sr. Data Scientist

Data integration

Image showing data integration as the next step after conditional statements and expression based transformation

What is data integration?

Image shows three step process with collect, enhance and sorting

Use case - Air travel

Image shows tables with flight and meal information

Append columns

Image shows combined information of flight and meals table

Meal preference

Image shows meal columns from meals table

Meal preference

Image shows meal1 as primary and meal2 as secondary column

Merge columns

Image shows the merge operation on meal1 and meal2 columns to create a new meal column

Context

Table shows the combined table with added information on date of flights

Constant value column

Image shows date column being added as constant value column

Constant value column

Image shows the combined table with flight meal and date information

Reorder column sequence

Image shows combined table with focus on date column to be shifted at the front

Reorder column sequence

Image shows date column being shifted to the first position.

Reorder column sequence

Image shows the idea of exchanging the position of price and meal columns.

Reorder column sequence

Image shows the price column is shifted at the end of the table.

Sorting

Image shows the first sorting criteria is for departure column and to sort it alphabetically

Sorting

Image shows the sorted table with first 2 rows showing data for departed flights from berlin.

Sorting - add criteria

Image shows second criteria of sorting the price column in descending order.

Sorting - add criteria

Image shows the table sorted with departure city and then price, so that the first row denotes the most expensive flight from berlin.

Let's practice!

Data Transformation in KNIME

Preparing Video For Download...