Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

Table of Contents
maxLevel2
excludeOlder Versions|Additional Resources|Related Links|Related Information

Overview

You can use this Snap to apply aggregate functions on input data using the Group By support. You can perform a calculation on a set of values to return a single scalar value.

...

The following are the commonly used SQL Aggregate functions:

...

The following example Pipeline shows how to use the Aggregate Snap to concatenate unique string values:

Snap Configuration

Output

Image ModifiedImage RemovedImage Added

Counting the Occurrences of a Given Product Name

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

Snap Configuration

Output

Image ModifiedImage RemovedImage Added

Downloads

Info
  1. Download and import the Pipeline into SnapLogic.

  2. Configure Snap accounts as applicable.

  3. Provide Pipeline parameters as applicable.

...