Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Error reading Excel Input File in PDI 4.2

  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Default Error reading Excel Input File in PDI 4.2

    Hi ,

    Our transformation executed successfully after using .xls file format. In the transformation we are using csv input and we have created a template in which we are making use of excel formulas in two columns J and K. The transformation is generating desired excel file (.xls) with formula calculation correctly.
    But when I am using the generated excel file as Input in another transformation and previewing that input step it is populating zeros in those formula fields. Whereas the Excel which we are inputting contains actual values calculated using those formulas.
    Need those actual values and not zeros when we preview the input step.
    Help greatly appreciated.

    Regards,
    Kedar.

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

    Default

    Hi Kedar.
    I think there's an option to recalculate the formula when you create your Excel file.
    Try to check that option and open your excel file in Excel to verify if that worked.

    Mick

Tags for this Thread

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.