Concatenate

We have two datasets containing sales records. The first data set has sales records from 2008 to beginning of 2011. The second data set 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. On the opposite the second dataset has a column "insurance" which the first dataset doies not have. Interesection of columns will exclude these two columns. Union of columns will include both columns filling the missing part with missing values

Concatenate

 

Resources

EXAMPLES Server: 02_ETL_Data_Manipulation/03_Joining_and_Concatenating/01_Concatenate02_ETL_Data_Manipulation/03_Joining_and_Concatenating/01_Concatenate*
Download a zip-archive

Video:

 

 


* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually