Grouping functions
Reference documentation for Expressif functions in the array/grouping scope.
| Name | Overview |
|---|---|
group | Groups pairs by structurally equal keys while preserving first-seen group and value order. |
group-by | Groups input values by keys calculated from one or more expressions. |
key | Associates the input value with a key calculated by one or more expressions. |
pivot | Groups values by row and column, applies a grouping summary, and reshapes the cells into records. |
unpivot | Converts selected present record fields into rows, preserving retained fields and source order. |