Transformation Components

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

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

First/Last Component

First/Last Component Allows the user to create groups of data and then return only the first or last rows from the group. Uses a Window Function Uses a Window Function Properties Property...

Lead/Lag Component

Lead/Lag Component Allows the user to determine a value from a preceding or following row at a given offset within a group (or partition) of values. Uses a Window Function. Uses a...

Map Values Component

Map Values Component Conditionally replaces one value with another in the data As the data is passed through the component rules are applied to specified columns to replace one value with another....

Rank Component

Rank Component Allows the user to determine the rank of a value in a group of values. Uses a Window Function Uses a Window Function Uses a Window Function. Properties Property Setting...

Rename Component

Rename Component Change the field names within the data flow. By default, all input columns are mapped into output columns of the same name. Any field can be dropped from the list...

Replicate Component

Replicate Component Send the output of a component to several other components. Only one component can flow into this one, but you can add as many outputs as you need. To do...

SQL Component

SQL Component Write your own complete SQL SELECT statement. This component can run queries on any tables in the project. You may link one or more inputs into the SQL component to...