Help and Support > Table of Contents > Combine



The Combine block combines two or more data sets into one. By looking at the column names it determines which columns are the same and creates a new table structure with all unique columns from the input datasets. It is possible to show all columns or to select only those columns that are common accross all inputs. If all columns are included then rows that come from input data sets without a given column will be included with _NULL_ values in that column.

Combine Image

Block Connection Stubs

  • 1,2 The data sets that are to be combined together.
  • 3 The combined data set.