Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • teekay
  • Spaces
  • Public
  • L1-DS KNIME Analytics Platform for Data Scientists - Basics
  • Solutions
  • 07 Join and Concatenate - Solution
WorkflowWorkflow

07 Join and Concatenate - Solution

Join Concatenate

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
Solution to an exercise for joining and concatenating data. Combine data tables side-by-side using the join operation. Put tables on top of each other with the concatenate operation. CHECK YOUR ANSWERS: Joiner: The number of rows is 32549 in all joined tables. No rows were discarded in the joining operations. Concatenate: The ID column is missing in the adult_scotland table. You need to select union of columns, if you want to include the ID column in the concatenated table.

External resources

  • Concatenate: Piling up Data Tables
  • Concatenate: Concatenate node
  • Joining Data Tables Part II: Left Outer Join, Right Outer Join, Full Outer Join
  • Joining Data Tables Part I: Inner Join
  • Joining Data Tables

Used extensions & nodes

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

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  • Go to item
    KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. 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