Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Csv file input - Number Format

  1. #1
    Join Date
    Dec 2007
    Posts
    5

    Question Csv file input - Number Format

    Any idea why do I getting the folowing error "'2007/12/23 17:42:14 - Table output.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : Because of an error, this step can't continue:
    2007/12/23 17:42:14 - Table output.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : CurrentPrice String : couldn't convert string value '5,080.15' to a number."

    The column 'CurrentPrice' is defined as BigNumber and the I tried all offered format's.
    Other definitions are:
    Decimal=.
    Group=,

    Any idea would be grateful

    -Ram

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Convert the field in Kettle to BigNumber before you hit the table output with a select values step.

    Regards,
    Sven

  3. #3
    Join Date
    Dec 2007
    Posts
    5

    Default still have an error

    I tried adding the conversion to number in Select Values step before entering the 'Table output' step but I am getting the following error:

    *****************************************************
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : Unexpected error :
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : org.pentaho.di.core.exception.KettleValueException:
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : CurrentPrice String : couldn't convert string value '5,080.15' to a number.
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.core.row.ValueMeta.convertStringToBigNumber(ValueMeta.java:893)
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.core.row.ValueMeta.getBigNumber(ValueMeta.java:1469)
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.core.row.ValueMeta.convertData(ValueMeta.java:2962)
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.core.row.ValueMeta.convertBinaryStringToNativeType(ValueMeta.java:1065)
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.core.row.ValueMeta.getBigNumber(ValueMeta.java:1462)
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.trans.steps.selectvalues.SelectValues.metadataValues(SelectValues.java:325)
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.trans.steps.selectvalues.SelectValues.processRow(SelectValues.java:366)
    2007/12/25 10:39:46 - Select values.0 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.trans.steps.selectvalues.SelectValues.run(SelectValues.java:426)
    2007/12/25 10:39:46 - Select values.0 - Finished processing (I=0, O=0, R=84, W=83, U=0, E=1)

    *****************************************************
    Any ideas?
    Thanks

    -ram

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.