Count the occurrences of a given product name

The following example pipeline demonstrates how to use the Aggregate Snap to count the occurrences of a given product name.

  1. Configure the JSON Generator Snap to pass product and order details. Then, use the Aggregate Snap to count the Order IDs and group the fields by Product names. To achieve this, configure this Snap with COUNT function and specify $Product.Name.


    Download this pipeline
  2. On validation, you can view the Product names along with the Order IDs in the output preview.


To successfully reuse pipelines:
  1. Download and import the pipeline in to the SnapLogic Platform.
  2. Configure Snap accounts, as applicable.
  3. Provide pipeline parameters, as applicable.