Aggregate and Pivot

In Excel you can use pivot tables to compute aggregated column statistics.


In Dataiku, to produce a dataset equivalent to an Excel pivot table, use the Pivot recipe.

The Group Recipe can also produce aggregated statistics, but no columns are pivoted. Think of it as creating an Excel pivot table without specifying any Column fields.

The reference documentation contains further information on both the Pivot and Group recipes.