Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to check NULL value in "Modified Java Script Value" step?

  1. #1

    Default How to check NULL value in "Modified Java Script Value" step?

    Is the following code the right way to do it? But PMSID field could have value 0 too.


    var pmsid_value = "" + PMISID.getInteger() ;
    if (pmsid_value == "0" ) {
    pmsid_value = 'N/A';
    }


    Thanks for the help in advance,
    Kinkoi

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

    Default

    Try:

    Code:
    PMISID.isNull()
    Matt

  3. #3

    Default

    Thank you.

    I also found the answer in section 6.10.5 of the FAQ doc

    doc\english\PDI 2.5.0 - FAQ.pdf

    "6.10.5. How to use something as NVL in javascript?"

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.