Icon

01_​Concatenate _​lizardo_​vanegas

Concatenation example

This workflow demonstrates the concatenation of two or more tables. It also shows how to treat the missing columns by selecting either the union or intersection of columns.

Three datasets containing sales records are used. Two of them, for the years 2010-2011 and 2012-2013, contain exclusive column "card". Another data set has an exclusive column "insurance".

This workflow demonstrates how to put two and more datasets together keeping the same structure with the use of theConcatenate Node. Three datasets contain information about sales for the years 2010-2011, 2011 only and 2012, 2013respectively. Concatenation of two tables Concatenation of multiple tables Union of ColumnsSales records2010-2011 Exclusive: "card"Sales records 2011Exclusive: "insurance"Intersection ofColumnsSales records 2012-2013Exclusive: "card"Union of ColumnsConcatenate CSV Reader CSV Reader Concatenate CSV Reader Concatenate This workflow demonstrates how to put two and more datasets together keeping the same structure with the use of theConcatenate Node. Three datasets contain information about sales for the years 2010-2011, 2011 only and 2012, 2013respectively. Concatenation of two tables Concatenation of multiple tables Union of ColumnsSales records2010-2011 Exclusive: "card"Sales records 2011Exclusive: "insurance"Intersection ofColumnsSales records 2012-2013Exclusive: "card"Union of ColumnsConcatenate CSV Reader CSV Reader Concatenate CSV Reader Concatenate

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2024-05-15
Last update: 2024-09-19
Created with KNIME version: v4.6.0
Tags: concatenationdata blendingETL

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!