Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Microsoft excel output step from Table output cannot display float value

  1. #1
    Join Date
    Feb 2014
    Posts
    14

    Default Microsoft excel output step from Table output cannot display float value

    Hi,


    i want to extract data from txt file, store data in table and then store in an excel file.

    -txt file content: id,date,sensor
    1,2014-03-31 00:00:00, 10.25

    -store data in table mysql is working pefect.



    So i used:
    Read multiple file step------>Table output step-------->Microsoft excel output step
    (ok) (ok) (cannot show float value)

    The problem is when i extract data from step2 to step3, data are displayed like 10.00 instead of 10.25

    please check image below.

    Name:  test.jpg
Views: 29
Size:  36.8 KB

  2. #2
    Join Date
    Nov 2013
    Posts
    9

    Default

    Hi,

    To solve this, u need to check the following

    1.Check data type of sensor, it should be number in text input step.
    2.Check data type of sensor in create Table syntax,it should be numeric in greenplum .
    eg:
    CREATE TABLE schema.filetest1
    (
    id integer,
    dateq integer,
    sensor numeric);
    3. Similarly in excel ouptut step , data type of sensor.

    Regards,
    logu B

  3. #3
    Join Date
    Nov 2013
    Posts
    9

    Default

    Hi,

    To solve this, u need to check the following

    1.Check data type of sensor, it should be number in text input step.
    2.Check data type of sensor in create Table syntax,it should be numeric in greenplum .
    eg:
    CREATE TABLE schema.filetest1
    (
    id integer,
    dateq integer,
    sensor numeric);
    3. Similarly in excel ouptut step , data type of sensor.

    Regards,
    logu B

  4. #4
    Join Date
    Feb 2014
    Posts
    14

    Default

    Hi logu002.

    thank you, the problem is solved.

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.