Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Decimal point is suppressed on text column of text file

  1. #1
    Join Date
    Aug 2016
    Posts
    14

    Default Decimal point is suppressed on text column of text file

    I have a text file invoked from kettle on Input text file component. Each column of file is determined for its row position.

    I have a column with following text:

    -76.81889

    The input text file component process my file but erase decimal point. I've got this:

    Code:
    -76 81889
    Decimal point is suppressed...

    I don't know what's happened...

    Thanks for help me.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    I would check the format of that field and see what is the decimal separator
    -- Mick --

  3. #3
    Join Date
    Aug 2016
    Posts
    14

    Default

    Quote Originally Posted by Mick_data View Post
    I would check the format of that field and see what is the decimal separator
    The type of field is String. I configured dot(.) as decimal point but I get the same...

    It's strange that in my PC I don' have problems but in server do happen this error...

  4. #4
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    If you configure that field to be String, then the decimal point setting should not apply to it.
    Are you sure that the Text File Input step that is running on your server is configured to read that field as String?
    -- Mick --

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.