Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Changing type for amount

  1. #1

    Default Changing type for amount

    Hello,

    I've got a file to transform which contain the column ...;"122.30";="information";="other info"

    The problem is that also if I put
    Format #,##0.## (I tried with .00 it works but set me 122,00 of course)
    Length 10
    Precision 2
    Decimal ,

    I've got 122 out and not 122,30

    If I first get out the equals and double quotes and alterate the structure with these parameters, i've got the same results..

    What should I put in to make it work ?

    Thank you for your help

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    If you send it to a Text File Out, rather than the Preview, what do you see?

    Will you always have two places? You might be able to use #0.00 as a mask instead.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

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.