Adding Data Transposer to a project opens a component window. The Data Transposer component has one IN-Port and one OUT-Port. All generated output records are forwarded to the same OUT-Port. This feature allows to normalize data structures typical to mainframe files or spreadsheets.
To use the Data Transposer
Create a default mapping between the IN-Port structure and the OUT-Port structure. This default mapping is shared for subsequent mapping tabs. A default mapping is optional.
Create new tab. Creating a new tab will create an additional output record.
For the tab created in the previous step, map the IN-Port structure to the OUT-Port structure. Use the Enforced Output Value column to assign expressions to the OUT-Port attribute.
A new output record is created by pushing the Insert Button located on the toolbar of the Transposer window. This will generate a new Tab in the Tab-section of the window. If a default mapping was created, each generated output record will inherit this mapping. The Tab-section consists of the Tab Default and n Tabs, where n is the number of copies that will be generated for each single input record.
After connecting the component to the adjacent components:
Check the structure of the IN-Port and OUT-Port.
Open the component window. The current IN-Port and OUT-Port structure is displayed in the Default mapping tab. If all the OUT-Records share a common mapping, this is the place to assign that mapping.
Click the Insert button to create an output record structure. A new mapping area will be displayed. If a default mapping had been assigned, the appropriate attributes will already be connected.
Create a mapping between the IN and the OUT structure:
Connect two opposite connection points of the Mapping Area.
Use an expression in the Enforced Output Value column
to assign a calculation, for example: uConcat('Arrival
Date: ',uDate('now','localtime'),' ',uTime('now','localtime')).
Referencing IN-Port variables is not allowed.
Go back to step 6 to create more output record structures.
