Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: null values with Add constants

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default null values with Add constants

    Hi,


    Is it possible to insert a Null value with the Add constants step? I'm trying to create a BigNumber field with a null value by leaving the Value field empty (instead of a 0, it has a different meaning in my application) but I get the following exception:



    2006/03/27 21:16:38 - Add constants macro_data - ERROR : Couldn't parse BigNumber field precisionnum[img]/wiki/images/newpage.gif[/url] with value <u></u> -->java.lang.NumberFormatException



    I'm also trying to use the Null if step, by specifying a constant number to turn to Null, but it doesn't seem to work (the field keeps the number I gave it in the Add constants step).



    Any ideas? Is it possible to set a null value for a BigNumber field?



    Thank you

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

    Default RE: null values with Add constants

    Actually, it&#39;s an oversight: I forgot to do null values in the Constant step.
    Sorry about that. I&#39;ll add a feature request and implement this later today.
    The build system is down, but you should be able to get a development build later this week.

    The workaround is perhaps simple at the moment: put 1 in the BigNumber
    Then put a javascript after it that says: Field.setNull();

    Thanks for the feedback!

    Matt

  3. #3
    Join Date
    Jul 2010
    Posts
    10

    Default

    Hi Matt,

    Is this feature available in Kettle 4.0.1? Thanks.

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.