Transformation Components

Window Calculation Component

Window Calculation Component Allows the user to set up a calculation using a window function. Window functions allow users to query tables for a partition of a data set, termed a 'window'....

Rewrite Table Component

Rewrite Table Component Write the input data flow out to a new table. Runtime errors may occur, for example if a data value overflows the maximum allowed size of a field. Note:...

Table Output Component

Table Output Component Write the input data flow out to an (existing) output table Note: Successful validation of this component ensures the target table exists, and the target columns have been found....

Table Update Component

Table Update Component Update a target table with a set of input rows. The rows to update are based on matching keys. It is very important that the keys uniquely identify the...

Split Field Component

Split Field Component Split up the value of a column in an input flow according to a specified delimiter. This delimiter can be any valid character or sequence of characters. Properties Property...

Transpose Columns Component

Transpose Columns Map sets of input columns into new output columns. This effectively performs an unpivot on the data. This component re-shapes data by outputting multiple rows for each individual input row....

Detect Changes Component

Detect Changes Component Scan two separate yet similar tables, and insert a new column detailing if data has been inserted, deleted, changed or is unchanged. Any rows with key columns containing null...

Create View Component

Create View Component The "Create View" component allows you to output a view definition to the Redshift cluster. In some circumstances, that may be preferable to writing the data to a physical...

Flatten Variant Component

Flatten Variant Component 'Flattens' (explodes) compound values into multiple rows. When an input column (of Variant type) contains many values, Flatten Variant can seperate those values, giving each their own column. For...

Transpose Rows

Transpose Rows This component is essentially the opposite of the Transpose Columns component. Multiple rows are combined into a single output row (one for each value of the columns specified in the...