Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • knime
  • Spaces
  • Education
  • Courses
  • L1-DW KNIME Analytics Platform for Data Wranglers - Basics
  • Exercises
  • 06_Data_Aggregation_Exercise
WorkflowWorkflow

Data Aggregation - Solution

Aggregate GroupBy Pivot Date&time ETL
+1
KNIME profile image

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
Solution to exercise 7 for the KNIME Analytics Platform for Data Wranglers course - Calculate multiple aggregation using the Pivoting and GroupBy node - Join grouped data - Extract date fields from a DateTime value - Handle missing values - Manipulate strings - Calculate new features using the Math Formula node

External resources

  • The Pivoting node
  • Advanced Aggregations with the GroupBy Node
  • Basic Aggregations with the GroupBy node
  • Slides (KNIME Analytics Platform for Data Wranglers)

Used extensions & nodes

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

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    KNIME profile image
    knime
  • Go to item
    KNIME Database Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    KNIME profile image
    knime
  • Go to item
    KNIME Distance Matrix Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    KNIME profile image
    knime
  • Go to item
    KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    KNIME profile image
    knime
  • Go to item
    KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    KNIME profile image
    knime
  • Go to item
    KNIME Statistics Nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    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