Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How to set a input field value to null

  1. #1
    Join Date
    Apr 2014
    Posts
    12

    Default How to set a input field value to null

    Hi I have a CSV file input. I would like to set the value of certain column values to null irrespective of the value that is contained.
    I tried modified java script . But I am not able to get the result column as NUll.

  2. #2
    Join Date
    Mar 2014
    Posts
    29

    Default

    Hi GirijaSankar,

    If You want to set the specific field value to null(irrespectively the value of the column) use the below expression
    inside the user defined java expression by specifying the same column name in new filed and select the column in
    which you want to replace with null
    States.equals("")?"null":"null".

    Thanks and Regards,
    Bhanu.

  3. #3
    Join Date
    Apr 2014
    Posts
    12

    Default

    Seems like this expression is not valid when the column itself is null.

  4. #4
    Join Date
    Apr 2014
    Posts
    12

    Default

    I have used States == null?"":""

    Thanks for the idea...

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.