The Stack tool takes two datasets and stacks them on top of each other vertically. The Stack tool stacks columns with the same name on top of each other. If some columns (e.g. revenue and amount below) are only present in one of the datasets, the columns will still be stacked but the row values will be NULL in the rows from the other dataset where the column is not present.

Columns with the same name that should be stacked must have the same data type

​
Configuration

The Stack tool doesn’t require any configuration. All you have to do is connect your two datasets and run the tool.

​
When To Use

The Stack tool is the tool to use whenever you have similar datasets that should be combined into a single table.

  • You have data from multiple files, for instance budgets, and want them in consolidated into a single datasets before further analysis
  • The Stack tool is powerful before a Pivot tool; you might have calculated a number of different metrics and want to consolidate them in a single view. You have a type column describing your metrics and a value column with the metric. Stacking them and pivoting the dataset aftewards would consolidate your metrics in a single overview.