Hub
Pricing About
WorkflowWorkflow

Split and stack table

takbb profile image
Draft Latest edits on 
Apr 15, 2024 6:50 PM
Drag & drop
Like
Download workflow
Workflow preview
Workflow showing a number of ways that a table can be split into subsets of columns and then stacked In these examples, there is a table of 20 rows and 27 columns and this is to be transformed into a table of 60 rows and 9 columns, with each column being named using the respective names of the first 9 columns This shows how to do this by Table Cropper and Concatenate, but also using UnPivot / Pivot and additionally shows ways to rename the columns. It also, in some cases, utilises components to address some of the complexity.
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.2.2
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.2

    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.2

    knime
  • Go to item
    NodePit Power NodesUnknown extension

    This is an unpublished or unknown extension.

    Philipp Katz, Daniel Esser; nodepit.com

    Version 1.4.0

Legal

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

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits