Separate the records with missing postal codes

Try Pentaho Data Integration and Analytics
Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA000-11
Follow these instructions to use the Filter Rows transformation step to separate out those records missing postal codes. These records are resolved later in the tutorial.
  1. Add a Filter Rows step to your transformation. Under the Design tab, select Flow > Filter Rows.
  2. Insert your Filter Rows step between your Read Sales Data step and your Write to Database step.
    1. Right-click and delete the hop between the Read Sales Data step and Write to Database steps.
    2. Create a hop between the Read Sales Data step and the Filter Rows step. Create a hop by clicking on the step, hold the SHIFT key down and click-and-drag to draw a line to the next step.
    3. Create a hop between the Filter Rows step and Write to Database step.
    4. In the dialog box that appears, select Result is TRUE.

    Hop dialog set to Result is True
  3. Double-click the Filter Rows step. The Filter Rows window appears.
  4. In the Step Name field, enter Filter Missing Zips.
  5. Click in The condition field to open the Fields window. The available conditions appear.
  6. In the Fields window select POSTALCODE and click OK.
  7. Click the comparison operator field, which is set to = by default. The Functions window appears.
  8. Select IS NOT NULL from the list of functions, and then click OK​ to close the Functions window.

    Filter rows is set postalcode is not null
  9. Click OK to exit the Filter Rows window.
    Note: You will return to this step later to configure the Send true data to step and Send false data to step settings after adding their target steps to your transformation.
  10. Save your transformation.