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 reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.