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

Data Transformation in KNIME

What is data integration?

Image shows three step process with collect, enhance and sorting

Data Transformation in KNIME

Use case - Air travel

Image shows tables with flight and meal information

Data Transformation in KNIME

Append columns

Image shows combined information of flight and meals table

Data Transformation in KNIME

Meal preference

Image shows meal columns from meals table

Data Transformation in KNIME

Meal preference

Image shows meal1 as primary and meal2 as secondary column

Data Transformation in KNIME

Merge columns

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

Data Transformation in KNIME

Context

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

Data Transformation in KNIME

Constant value column

Image shows date column being added as constant value column

Data Transformation in KNIME

Constant value column

Image shows the combined table with flight meal and date information

Data Transformation in KNIME

Reorder column sequence

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

Data Transformation in KNIME

Reorder column sequence

Image shows date column being shifted to the first position.

Data Transformation in KNIME

Reorder column sequence

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

Data Transformation in KNIME

Reorder column sequence

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

Data Transformation in KNIME

Sorting

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

Data Transformation in KNIME

Sorting

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

Data Transformation in KNIME

Sorting - add criteria

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

Data Transformation in KNIME

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.

Data Transformation in KNIME

Let's practice!

Data Transformation in KNIME

Preparing Video For Download...