Control stages
Control stages move data along different paths in a flow, to split or group records, and to perform basic data transforms and mathematical operations.
| Stage | Icon | Description | For more information |
|---|---|---|---|
| Aggregator |  |
Aggregator converts flat data to hierarchical data. It takes input data from a single source, creates a schema (a structured hierarchy of data) by grouping the data based on fields you specify, then constructs the groups in the schema. | Aggregator is not available in this release. |
| Broadcaster |  |
Splits a single stream of records into multiple streams, allowing you to send records to multiple stages for simultaneous processing. | Broadcaster is not available in this release. |
| Conditional Router |  |
Sends records to different paths in the flow depending on the criteria you specify. The stage can have one or more output ports, depending on the defined criteria. Output ports are numbered consecutively, starting with 1 (which displays as port). | Conditional Router is not available in this release. |
| Group Statistics |  |
The Group Statistics stage allows you to run statistical operations across multiple data rows broken down into groups that you want to analyze. If no groups are defined all rows will be treated as belonging to one group. | Group Statistics is not available in this release. |
| Math |  |
The Math stage handles mathematical calculations on a single data row and allows you to conduct a variety of math functions using one or more expressions. Data is input as strings but the values must be numeric or Boolean, based on the type of operation being performed on the data. | Math is not available in this release. |
| Record Combiner |  |
Record Combiner is a Control stage that uses one or more input ports to merge multiple records from multiple streams into a single survivor record based on a commonality | |
| Record Joiner |  |
Record Joiner performs a SQL-style JOIN operation to combine
records from different streams based on a relationship between fields in the
streams. |
Record Joiner is not available in this release. |
| Sorter |  |
Use the Sorter stage to sort records using fields you specify | Configure the Sorter stage |
| Splitter |  |
A Splitter converts hierarchical data to flat data. Splitters have one input port and one output port that delivers data from the Splitter to the next stage. | Splitter is not available in this release. |
| Stream Combiner |  |
Joins multiple record streams from multiple stages. Stream Combiner has one or more stage input ports. For example, you can have one group of records from one stage and another group from a second stage, and the records will merge into a single stream. | Stream Combiner |
| Transformer |  |
Flow Designer provides the building blocks (functions) that allow you to process, change, and convert data to suit your requirements. These transformations are configurable through the Transformer stage. This section provides a preview of the transforms available in Flow Designer. Note that only custom transforms are supported in this release of Flow Designer. | Creating and configuring data transformations |
| Unique ID Generator |  |
The Unique ID Generator stage creates a unique key that identifies a specific record. A unique ID is crucial for data warehouse initiatives in which transactions may not carry all name and address data, but must be attributed to the same record or contact. A unique ID may be implemented at the individual, household, business, and premises level. Unique ID Generator provides a variety of algorithms to create unique IDs. | Unique ID Generator is not available in this release. |