Introduction to aggregations

In this video, you will learn:

  • What aggregators are
  • How to use aggregators
  • Different types of aggregators
An aggregator is a module which receives multiple bundles as an input and produces a single output in your scenario. Essentially, it’s what ends or stops an iteration or multiple bundles being passed through your scenario. When setting up an aggregator, you need to identify where the iteration begins and essentially where you want it to end, and whether or not you want to use the advanced grouping option which allows you to produce multiple bundles based off of a criteria rather than a single bundle after the aggregator. A standard aggregator receives multiple bundles and produces a single array with specified fields as an output. There are numeric aggregators which result in a single value as the output, and you can use Sum, Average, Count, or other types of numeric aggregators. There’s table aggregators that result in a formatted table of text as a single output bundle, text aggregators, resulting in a single set of text as the output, aggregators to JSON, which result in a single JSON object, defined by a data structure that we can create, and then others which create CSVs, Archive files, or Microsoft Word templates. When using iterators and aggregators within your scenario, you’ll notice that a gray shadow will be produced between where the iteration begins and where the aggregation ends. Also, keep your mind open and creative to the possibilities. Notice in this visual we have an iteration and an aggregation happening within a larger iteration and aggregation. -