Stack

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Stack

Description

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

 

Inputs

One or more.

 

Example

Stacking these two datasets by the ID column in each:

 

merge example

merge

merge example

 

Gives:

 

merge example

 

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 case insensitive (e.g. 'id' to 'ID'), if no case sensitive match is possible.

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

 

Notes

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

 

See also

Cross

Join

Merge datasets