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...
Multi Table Input Component
Multi Table Input Component Read chosen columns from an input table into the job. The difference between Table Input and Multi Table Input is that Multi Table Input reads data from many...
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...