Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • knime
  • Spaces
  • Examples
  • 02_ETL_Data_Manipulation
  • 03_Joining_and_Concatenating
  • 01_Concatenate
WorkflowWorkflow

Concatenation example

Concatenation Data manipulation ETL

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
We have two datasets containing sales records. The first data set has sales records from 2008 to beginning of 2011. The second dataset has additional sales records for 2011 only. Each record is a sale with date, price, etc ... We want to put the two datasets together keeping the same structure, just piling up sales from 2008-2011 and sales from 2011 only. To do that we use the Concatenate node. The structure of the two datasets is slightly different. The first dataset has a column "card" which the second dataset does not have. In comparison, the second dataset has a column "insurance" which the first dataset doies not have. An interesection of columns will exclude these two columns. A union of columns will include both columns filling the missing part with missing values

External resources

  • Concatenation

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.1
  • Go to item
    KNIME Core Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  1. Go to item
  2. Go to item
  3. Go to item

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
Hardturmstrasse 66
8005 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 Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits