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

SQRT function on negative number is showing unreadable character

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Severity: Low
    • Resolution: Unresolved
    • Affects Version/s: 6.1.0.1 GA, 7.0.0 GA
    • Fix Version/s: Backlog
    • Component/s: Step
    • Labels:
    • Story Points:
      0
    • PDI Sub-component:
    • 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 are using Calculator step with SQRT function on negative number.
      But the result is showing unreadable character.

      I am attaching a sample transformation. In this transformation you can see that I am trying to do a SQRT(-5). This is showing unreadable character.

      We would like the function to show the value as "Invalid Input" or as NaN.

        Attachments

        1. 277_modified.ktr
          13 kB
        2. 277.ktr
          9 kB
        3. Capture.PNG
          Capture.PNG
          48 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              gdev Gurudev
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: