Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Result of Select Values

  1. #1

    Default Result of Select Values

    I developed the PDI version 3.2.3 on the Windows platform. And ran smoothly.

    I am running on version 3.2.3 and 4.0 on the Linux platform:

    The step CSV file input is linked in the Select values step.

    The Step CSV file input:
    Reading this Step is correct, as can be seen the configuration and the result in figures: CSV Input.png, and CSV-Examine preview data.png.

    The Step Select values:
    The configuration and the result of Step can be seen in figures: Select - Rename values.png, and Select values - examines preview data.png.

    This result is not returned 9,999,999.99 in the last row. Why?

    Thank you.

    Sort by posting the pictures:
    1) CSV Input.png
    2) CSV-Examine preview data.png
    3) Select - Rename values.png
    4) Select values-Examine preview data.png
    Attached Images Attached Images     

  2. #2

    Default

    Who can help me?

  3. #3
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi there,

    would it help to specify the decimal and grouping symbols manually (in the csv or select values step)?
    . is the grouping symbol and , is the decimal symbol for your input, if I understand the screenshots correctly.

    you may also consider setting the format string when converting your number. For your input #.## seems about right.

    If nothing helps you could attach a self-contained example that shows the issue (use generate rows or attached csv sample file). I'd be glad to have a look at it.

    Cheers
    Slawo

  4. #4

    Default

    Hello,

    you ran on what operating system?

    I think it is more understandable with files attached.
    I would like the values that are in the csv file, go out in the Dummy step.

    Note: But, I point out that there is a difference by running Windows and Linux.

    Thanks.
    Attached Files Attached Files

  5. #5
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi there,

    I've added the correct decimal and grouping symbols and now it works for me on 3.2 and 4.0 alike, unless I am missing something. Results are attached.

    All the best

    Slawo
    Attached Files Attached Files

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.