Icon

03_​JoinConcatenate_​Examples

Join and Concatenation Examples

On adult.csv data set:
1. calculate the average age and number of rows for the 4 groups (sex, income) and join the corresponding 2 values to each row in the group
2. extract people with age between 20 and 40 and working in a work group starting with "S" and people with age between 40 and 60 and working in the Private sector (workclass starts with "P"). Put both groups in a single data table.

Extract people with:age in (20,40) and working as self* +age in (40,60) and working in Private Add group average age and row count to each row in (sex,income) groups This workflow is an example of using the Joiner and the Concatenate nodes on the same dataset. For more information see the workflow metadata. Find it here: View -> Description Readingadult.csv20 < age < 40Workclass = S*count total number of rows and calculate avg agein the 4 groups definedby sex and incomejoin avg and count on sex and incomeWorkclass = P*40 < age < 60 File Reader Row Filter Row Filter GroupBy Joiner Concatenate Row Filter Row Filter Extract people with:age in (20,40) and working as self* +age in (40,60) and working in Private Add group average age and row count to each row in (sex,income) groups This workflow is an example of using the Joiner and the Concatenate nodes on the same dataset. For more information see the workflow metadata. Find it here: View -> Description Readingadult.csv20 < age < 40Workclass = S*count total number of rows and calculate avg agein the 4 groups definedby sex and incomejoin avg and count on sex and incomeWorkclass = P*40 < age < 60 File Reader Row Filter Row Filter GroupBy Joiner Concatenate Row Filter Row Filter

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: rosy
Created at: 2017-01-31
On NodePit since: 2019-07-12
Last update: 2024-05-02
Created with KNIME version: v4.1.1
Tags: JoinConcatenateETL

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

Try NodePit Runner!