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

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

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. By default, all input columns are mapped into output columns of the same name. You can...

Convert Type Component

Convert Type Component Convert the data types of the input flow. If possible, it is better to change the source data so that it already has the correct types. However, sometimes it...

Distinct Component

Distinct Component Pass on only the distinct (or unique) input records to the next component. Properties Property Setting Description Name Text The descriptive name for the component. Columns Selection Only these selected...