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 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