In this article
...
Use this Snap to add aggregate functions such as COUNT, SUM, MIN, and MAX along with the GROUP BY clause in the incoming SQL query. GROUP BY clauses are used to group table records based on columns that contain classifying data and are optional in this Snap. This Snap also allows you to preview the result of the output query. You can validate the modified query using this preview functionality. The supported aggregate functions vary based on the account configuration. See the description of the Aggregate Function field in the Snap Settings section for details.
Prerequisites
None.
Limitations
...
Multiexcerpt macro | ||||
---|---|---|---|---|
| ||||
|
Known Issues
- The Snap does not apply the sort order defined in the ORDER-BY Fields (Aggregate Concatenation Functions Only) fieldset to the Aggregate concatenation function resultsIf you have defined a HAVING predicate in the HAVING Predicate List field set of the ELT Aggregate Snap to apply on the Snap’s output data, the Snap connected downstream of this ELT Aggregate Snap returns an error corresponding to this predicate during the Pipeline execution.
Multiexcerpt include macro | ||||||
---|---|---|---|---|---|---|
|
...