We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Consolidate a table by grouping rows on key fields with an aggregate function
Groups the rows of the source table by the specified key fields and applies an aggregate function (MAX, MIN, AVG, SUM, or COUNT) to the remaining columns, writing the result to a new table. Useful for summarising imported data before further processing.
| Parameter | Description |
|---|---|
| cmd | Source table name |
| Argument 0 | Destination table name for the consolidated result |
| Argument 1 | Comma-separated list of key fields to group by |
| Argument 2 | Aggregate function to apply to non-key columns: MAX, MIN, AVG, SUM, or COUNT |
ConsolidateTable "Source table name", "Destination table name for the consolidated result", "Comma-separated list of key fields to group by", "Aggregate function to apply to non-key columns: MAX, MIN, AVG, SUM, or COUNT"