Control

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.
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. 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 Combiner
Record Joiner Record Joiner performs a SQL JOIN operation to combine records from different streams based on a relationship between fields in the streams. Record Joiner
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
Note: Not available in this release.
Transformer Flow Designer provides transformer building blocks in the form of functions that allow you to process, change, and convert data to suit your requirements. Creating and configuring data transformations
Unique ID Generator The Unique ID Generator stage creates a unique key that identifies a specific record. Unique ID Generator