Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Unable to process bunch of excel workbench format files.

  1. #1

    Default Unable to process bunch of excel workbench format files.

    Hi Folks,
    I'm using spoon 5.2 when I use the component "Text file Input" for attaching multiple files(excel worksheet) from a directory ,in the file tab of this component when I click on "show file content" button it gives me with some junk value.
    please help me on this.
    thanks :-)

  2. #2
    Join Date
    Oct 2013
    Posts
    216

    Default

    Why you are not using Microsoft Excel Input Step ?
    -- NITIN --

  3. #3

    Default

    Thanks for Acknowledging my post @Nitin.
    Since I have to work with around 200-300 excel files which have a same format, so thought y nt to put it into one location and pick up that directory at once

  4. #4
    Join Date
    Oct 2013
    Posts
    216

    Default

    In Microsoft Excel Input you can also able to select directory or multiple files.
    -- NITIN --

  5. #5

    Default

    okk... I'll try that , since I'm beginner to PDI(Kettle) that's why facing such small small issues
    once again thanks for assisting :-)

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.