Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-1034

Add step to create ranges based on numeric field (code donation)

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.0.2, 3.0.3, 3.1.0 GA
    • Fix Version/s: 3.2.0 GA
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      We often require to assign a range to a row based on a numeric field.

      For example:

      • Assign mega pixels information for products into brackets like 'Up to 3Mpx', '3-5Mpx', '5-9Mpx', "more than 9Mpx'
      • Assign default bracket if no information was provided, e.g. 'unknown' if price information is empty

      In case it's interesting functionality for more people please find attached the code for this step.

        Attachments

        1. NumberRangeRuleTest.java
          1 kB
        2. NumberRangeSetTest.java
          3 kB
        3. patch.txt
          34 kB
        4. range.png
          range.png
          1 kB
        5. screenshot.jpg
          screenshot.jpg
          37 kB

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ronnyroeller Ronny Roeller
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: