Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Extraction from Excel

  1. #1
    Join Date
    Feb 2011
    Posts
    1

    Default Extraction from Excel

    Hello,

    In Pentaho Data Integration, I want to do an extraction from an excel file, but it does not work, the problem is that each field is in a box , I tried to convert the file in csv format in order to have fields between ""and separated by; (because it works for a csv file with fields that are between ""and separated by but the fields remain in boxes in the converted csv file.

    I prefer a solution where I did not need to convert to csv (direct extraction from the excel file), but I'm interested in any solution.

    And thank you in advance.

  2. #2
    Join Date
    Dec 2009
    Posts
    609

    Default

    Hi,

    what´s wrong about the "Excel Input Step" and configuring the "Sheet" and "Field" Tabs correctly?

    Best regards,

    Tom

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.