Stack

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Stack

Description

Merge rows from inputs, one on top of the other.

 

Example

Stacking these two datasets:

 

merge example

merge

merge example

 

Gives:

 

merge example

 

Inputs

One or more.

 

Options

Select Align columns by to Header name if you want line up column values by header name (e.g. the 'id' column in input 1 with the 'id' column in input 2) and Column number to align by the column number (e.g. the first column of input 1 with the first column of input 2). The headers will be matched in order:

ocase and whitespace sensitive (e.g. 'ID' to 'ID'); then

ocase insensitive and whitespace sensitive (e.g. 'Id' to 'ID'); then

ocase sensitive and whitespace insensitive (e.g. 'ID' to ' ID '); then

ocase and whitespace insensitive (e.g. 'Id' to ' ID ')

The stacking order depends on the vertical (Y-axis) position of the inputs.

 

Notes

Stack merges two datasets one on top of the other (vertically). To merge datasets side-by-side (horizontally) use Join.

If you align by Column number the header of the first input is used.

Messages are shown in the Warnings tab for duplicated column names within an input dataset when Align columns by is set to Header name.

 

See also

Cross

Join

Merge datasets