Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How can I turn a NULL value into another value?

  1. #1

    Default How can I turn a NULL value into another value?

    I'm trying with ValueMapper but it can't map NULL values. Any alternative or should we fix ValueMapper to work with NULL values?

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: How can I turn a NULL value into another value?

    Well, calculator has an NVL() function that does just that.
    However, perhaps adding the support to ValueMapper would be more intuitive :-)
    That function is doing just strings though. (one value to a String)

    Matt

  3. #3

    Default RE: How can I turn a NULL value into another value?

    Agreed!

    I have just gone through some testing on my transform to see how to do this the best way. I tried the Java/Javascript step, Calculator, and ValueMapper (althought that was not much use .

    In the end, the best performance for MySQL was to use the COALESCE function when doing the select in the table input step.

    Regards
    Jonathon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.