Passthru Transformation

A Passthru Transformation creates a new dataset based on the elements that were passed to the transformation. This is useful for organizing datasets for better readability and grouping of values that are otherwise calculated over and over again (e.g. a Sequence Generator Transformation).

Usage

To use a Passthru transformation, drag and drop the Passthru Transformation from the Transformations Group in the Flow toolbox to the flow designer.

Map all the data to the Passthru transformation created by the flow designer. These will be the data for the new dataset.

The properties window has the option of adding new member objects, or Collection Objects. This is where the dataset can be organized based on what is needed.

Example

In this example, we are creating a new dataset from:

• the EmployeeID and LoginID from an Excel source file

• a Variable called RoomID

• a Sequence Generator Transformation which will generate the CubicleID

and mapping it to two Excel destination files.

The Passthru Transformation gives a nice option of grouping the data needed for other tasks and storing any calculated data for each element of the dataset. In this example, the Sequence Generator can assign a unique CubicleID for each employee and still retain the same value on both the excel destinations.