Filter Component
Filter Component Filter rows from the input to pass a subset of rows to the next component based on a set of conditions. The function of this component is similar to the...
Aggregate Component
Aggregate Component This component works by grouping together multiple input rows into a single output row. Input columns can be added to the groupings, or have an aggregation applied to them. Default...
Fixed Flow Component
Fixed Flow Component Allows you to generate lines of fixed input, or input from variables. Useful for simple static mappings Properties Property Setting Description Name Text The descriptive name for the component....
Generate Sequence Component
Generate Sequence Component Generates a sequence of rows from a starting value to an ending value with a user defined increment. This can be used to generate empty rows of data from...
Table Input Component
Table Input Component Read chosen columns from an input table or view into the job. This component will also work with external tables. Properties Property Setting Description Name Text The descriptive name...
Except Component
Except Component Compares two input flows and outputs any rows from the primary table that do not exist in the comparison table. Because the entire row is compared, only overlapping columns are...
Intersect Component
Intersect Component Compares two input flows and outputs any rows that are in common (identical) in both tables. Because the entire row is compared, only overlapping columns are considered, otherwise no rows...
Join Component
Join Component Join 2 or more input flows into a single output. Join conditions are defined using expressions which can be calculated from the input columns. Join expressions can be simple or...
Unite Component
Unite Component Combine all the rows from two or more input flows into a single output flow. The input flows should be very similar for this component to be useful, although slight...
Calculator Component
Calculator Component Adds new columns by performing calculations. Each row in produces one row of output. Any pre-existing columns that share a name with a created column will be overwritten. By default,...