Add a Value mapper step to the transformation

Try Pentaho Data Integration and Analytics
Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA000-11
Follow these steps to add the Value mapper step to the transformation.
  1. Delete both hops connected to the Write to Database step. For each hop, right-click and select Delete.
  2. Create some extra space on the canvas. Drag the Write to Database step toward the right side of your canvas.

    Add space on canvas for Value mapper step
  3. Add the Value mapper step to your transformation by expanding the Transform folder and choosing Value mapper.
  4. Create a hop between the Filter Missing Zips and Value mapper steps. In the dialog box that appears, select Result is TRUE.
  5. Create a hop between the Prepare Field Layout and Value mapper steps. When prompted, select the Main output of the step option.

    Add Value mapper step to the canvas