Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • knime
  • Spaces
  • Beginners Space
  • 03_Transform
  • 01_Transform_Using_Group_By_and_Joiner_nodes
WorkflowWorkflow

Transform Data using GroupBy and Joiner nodes

ETL KNIME Data manipulation Onboarding Spreadsheets
+5
KNIME profile image

Last edit:

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
In this workflow, a number of ETL operations are performed on the sales2008-2011.csv dataset. Besides showing what ETL features are, the goal of this workflow is to move from a series of contracts with different customers in different countries to a one-row summary description for each one of the customers. The one-row description includes: 1. the customer's unique ID 2. the total amount of money paid by the customer to the company 3. the countries the customer has been active in 4. the date of the first contract (this is always useful to estimate customer loyalty) 5. the number of days between the first and the last purchase, that is the number of days the customer has been with the company In the end, each one-row customer summary information is joined together with each contract data row from the original file and the resulting table is written to a CSV file in a "data" folder located in the workflow folder.

External resources

  • KNIME Self Paced Course
  • KNIME Cheat Sheet : Building a KNIME Workflow for Beginners
  • What's data aggregation? - KNIME TV -YouTube
  • Basic Aggregations with the GroupBy node - KNIME TV - YouTube
  • ETL with KNIME. What is a Join operation - KNIME TV - YouTube
  • ETL with KNIME. The Joiner Node - Part I - KNIME TV - YouTube
  • ETL with KNIME. The Joiner Node - Part II - KNIME TV - YouTube

Used extensions & nodes

Created with KNIME Analytics Platform version 4.5.2
  • Go to item
    KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Versions 4.5.1, 4.5.2

    KNIME profile image
    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item
Loading deployments
Loading ad hoc executions

Legal

By using or downloading the workflow, you agree to our terms and conditions.

Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits