Transformation Components

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. Properties Property Setting Description Name Text The descriptive name...

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.   Properties Property Setting Description Name Text The descriptive name for the component. This is automatically determined...

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...