Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: table input preview number 0.812 -> 0.8

  1. #1
    Join Date
    Nov 2008
    Posts
    28

    Default table input preview number 0.812 -> 0.8

    version pdi-ce-3.2.0-stable
    mysql version 5.0.27

    table input step
    column type decimal(7.3)

    data preview
    0.812 -> 0.8
    1.985 -> 2
    37.187 -> 37.2

    It rounds it off by the second digit of the decimal point.
    So that it is not rounded off

    table input step -> insert/update step
    The value enters correctly.

    table input step -> Execute SQL script
    It is rounded off.
    For no half-adjust

  2. #2

    Default

    You do realize you don't actually ask a question in your post? Anyway data is previewed rounded in PDI but internally is should still retain its decimal places

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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

    Default

    Tom, I'm sure ken5678 knows more English than you do Japanese :-)

    Anyway, the " #.#" formatting mask is there for compatibility reasons towards PDI 2.x.
    We're working on ways to set these features globally, but it's not that easy to do.

    For now, you can use a "Select Values" step to change metadata like "conversion mask" if you like.

  4. #4
    Join Date
    Nov 2008
    Posts
    28

    Default Thank you.

    use select values.
    It solved it.

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.