Differences

This shows you the differences between two versions of the page.

--- transformations:pivot [2016/06/19 20:01] – dmitry
+++ transformations:pivot [2020/01/22 04:37] – dmitry
@@ Line 26: / Line 26: @@
 | Norway  |  23  |  26  |
 | Germany  |  30  |  19  |
+Note that grouping works implicitly in the "Pivot" action. Groups are formed by combination of values in other columns that not labels or data. Values in a group are aggregated into 1 row. For instance in the example above, column [Country] was used for implicit grouping, because two other columns, [Season] and [Medals], were used for labels and data respectively.
+If a pivoted dataset has only two columns, one of which is used for data, and the other for labels), then the resulting dataset will always have only 1 row.
 **See also**
   * [[transformations:unpivot|Unpivot]]