Apply ranges

Try Pentaho Data Integration and Analytics
Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA000-11
Follow these steps to apply ranges to your transformation.
  1. Add a Number range step to your transformation by expanding the Transform folder and selecting Number range.
  2. Create a hop between the Value mapper and Number range steps.
  3. Create a hop between the Number range and Write to Database (which was built using Table output) steps. When prompted, select the Main output of the step option.

    Add Number range step to the canvas
  4. Double-click the Number range step to open its properties dialog box.
  5. Click in the Input field and select SALES from the list.
  6. In the Output field enter DEALSIZE.
  7. In the Ranges (min <=x< max) table, define the Lower Bound and Upper Bound field ranges along with the bucket Value.
    1. In row #1, click the field in the Upper Bound column and enter 3000.0. Then, click the field in the Value column and enter Small.
    2. In row #2, click the field in the Lower Bound column and enter 3000.0. Then, click the field in the Upper Bound column and enter 7000.0. Click the field in the Value column and enter Medium.
    3. In row #3, click the field in the Lower Bound column and enter 7000.0. Then, click the field in the Value column and enter Large.

      Set ranges in Number Range step
  8. Click OK.