Differences

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

--- transformations:aggregate [2015/05/01 08:48] – dmitry
+++ transformations:aggregate [2020/02/10 11:21] – dmitry
@@ Line 10: / Line 10: @@
   * Min
   * Max
+  * Any
 EXAMPLE
@@ Line 25: / Line 26: @@
 | Paraná  |  4880  |  South America  |
-**Objective:** Find out which are the longest rivers on each continent.
+**Objective:** Find out the longest river on each continent.
 **Transformation parameters:**
@@ Line 41: / Line 42: @@
 | Amazon  |  South America  |  6400  |
+=== Notes ===
+The "Any" aggregation picks only 1 arbitrary (random) value from a group of values and discards the rest.
+The "Any" aggregation is typically used for non-numeric values, where all values in a group are known to be the same. E.g. "Any" applied to "ABC", "ABC", "ABC" will return "ABC".