6.1 Ordinary grouping: by field value
Calculate total sales amount of each product based on the following daily sales table.
| Date | Product | Sales |
|---|---|---|
| 2022-01-01 00:00:00 | Cereal | 98.0000 |
| 2022-01-01 00:00:00 | Meat | 174.0000 |
| 2022-01-02 00:00:00 | Cereal | 168.0000 |
| 2022-01-02 00:00:00 | Meat | 167.4000 |
| 2022-01-03 00:00:00 | Cereal | 1696.0000 |
| … | … | … |
SPL script:
| A | |
|---|---|
| 1 | =T(“DailySales.xls”) |
| 2 | =A1.groups(Product;sum(Sales):Sales) |
| 3 | =A1.group(Product;~.sum(Sales):Sales) |
A2 Group A1’s table while performing sum aggregation without generating grouped subsets.
A3 Generate grouped subsets and then perform sum aggregation on each subset; this gets same result as A2.
Execution result:
| Product | Sales |
|---|---|
| Cereal | 309998 |
| Meat | 174645 |
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProcSPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL
