Transforming the data

About this task

Configuring tMap

Double-click tMap to open the Map Editor.
Drop the four columns of the input schema from the input side (left) into each of the output flows of the output side (right), that is to say, out1 and reject. This way the input flow and the output flows are mapped.
In the table representing the out1 flow, click to display the filter editing area and enter the following expression to select the employee records that were registered before January 1^st, 2008 (01-01-2008). row1.Reg_date.before( new Date(108,0,1))
In the table representing the reject flow, click to display the property settings panel.
In the Value field of the Catch output reject row, click the and select true in the pop-up dialog box. This allows you to output the records rejected by the out1 flow.
Click OK to validate these changes and accept the propagation prompted by the pop-up dialog box.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!