Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: kettle version 3.0.0 - integer type

  1. #1

    Default kettle version 3.0.0 - integer type

    Hi,

    Ive got interesting problem. I fetch id column from database containing integers like for example 7 than i need it convert to string, but pentaho makes 0000007 from this integer. Why is that, and when i can switch the nulls off ??

    Thx.

  2. #2
    Join Date
    Mar 2007
    Posts
    216

    Smile

    Hi,

    Quote Originally Posted by paveluk View Post
    Hi,

    Ive got interesting problem. I fetch id column from database containing integers like for example 7 than i need it convert to string, but pentaho makes 0000007 from this integer. Why is that, and when i can switch the nulls off ??

    Thx.
    Maybe the 00000007 issue may be resolved by specifiying a length=1.
    To switch the nulls off you may use a Filter Rows steps with the condition "IS NULL" and link the "false" output to what you want and "true" output to Dummy step.

    a+, =)
    -=Clément=-

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

    Default

    In version 3.0.1 with the metadata tab of the Select Values step, you can assign any mask you want to do any kind of Number, Integer, BigNumber or Date presentation (as String) you like.

    Matt

  4. #4

    Default

    Youre advice with using Filter Rows doesnt work. The problem is in kettle version 3.0.0 i have to use older version 2.5.0. It fetch my ids without nulls before it.

    Quote Originally Posted by clement View Post
    Hi,



    Maybe the 00000007 issue may be resolved by specifiying a length=1.
    To switch the nulls off you may use a Filter Rows steps with the condition "IS NULL" and link the "false" output to what you want and "true" output to Dummy step.

    a+, =)
    -=Clément=-

  5. #5
    Join Date
    Mar 2007
    Posts
    216

    Smile

    Hi,

    Quote Originally Posted by paveluk View Post
    Youre advice with using Filter Rows doesnt work. The problem is in kettle version 3.0.0 i have to use older version 2.5.0. It fetch my ids without nulls before it.
    That's when I realize that I misunderstood what you meant with "nulls".
    You were talking about 0 above 7 like in 0000007.
    I thought that you wanted to squeeze NULL rows.
    Sorry.

    a+, =)
    -=Clément=-

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.