Icon

ciullajn Aggregation and Data Blending Custom Data

John CiullaExercise 3 Task 1: Aggregate data with the GroupBy node1. Read the airports2. Calculate the number of altitude by country3. Calculate the minimum and maximum altitude Task 2: Aggregate data with the Pivoting node1. Read the subtracted data2. Create a pivot table that shows the number of total pos/neg Task 3: Join tables1. Read the population, life expectancy, geo coordinates, and travel advisories data by executing the providedreader nodes2. Join all tables based on RowIDs. Use inner join.3. Edit Bell airline to BELL Task 4: Concatenate tables1. Read airlines and airplanes csv2. Concatenate the tables. Use union of columns. airports.csvGroup By AltitudeMin/Max AltitudeTotal on Pos NegData (Pos/Neg)airports.csvroutes.csvairlines.csvairplanes.csvInner Join on RowIDChange BELLInner Join on RowIDInner Join on RowIDairlines.csvairplanes.csvConcat the tables CSV Reader GroupBy GroupBy Pivoting Metanode CSV Reader CSV Reader CSV Reader CSV Reader Joiner Table Editor Joiner Joiner CSV Reader CSV Reader Concatenate John CiullaExercise 3 Task 1: Aggregate data with the GroupBy node1. Read the airports2. Calculate the number of altitude by country3. Calculate the minimum and maximum altitude Task 2: Aggregate data with the Pivoting node1. Read the subtracted data2. Create a pivot table that shows the number of total pos/neg Task 3: Join tables1. Read the population, life expectancy, geo coordinates, and travel advisories data by executing the providedreader nodes2. Join all tables based on RowIDs. Use inner join.3. Edit Bell airline to BELL Task 4: Concatenate tables1. Read airlines and airplanes csv2. Concatenate the tables. Use union of columns. airports.csvGroup By AltitudeMin/Max AltitudeTotal on Pos NegData (Pos/Neg)airports.csvroutes.csvairlines.csvairplanes.csvInner Join on RowIDChange BELLInner Join on RowIDInner Join on RowIDairlines.csvairplanes.csvConcat the tables CSV Reader GroupBy GroupBy Pivoting Metanode CSV Reader CSV Reader CSV Reader CSV Reader Joiner Table Editor Joiner Joiner CSV Reader CSV Reader Concatenate

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: John
Created at: 2023-05-16
On NodePit since: 2023-05-17
Last update: 2024-05-02
Created with KNIME version: v4.7.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!