Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Loading Multiple Excel files in one Input Step

  1. #1
    Join Date
    Dec 2010
    Posts
    193

    Exclamation Loading Multiple Excel files in one Input Step

    Hi,

    Is it possible to parameterize and load various excel files available in different paths and load it into target without specifying fields ?
    Sathish
    Back to Pentaho


    'Be the best Pearl in the ocean of wisdom'

  2. #2
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    No.

    You HAVE to specify where the data is going.
    If the files have the same layout, then you can load all the files in various paths, but if they don't have the same layout, then you can't
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  3. #3
    Join Date
    Nov 2008
    Posts
    777

    Default

    Quote Originally Posted by satran View Post
    ...without specifying fields?
    No. gutlez is definitely right on that one.

    What you might be able to do though is configure an MS Excel Input step that has, say, 8 generic columns (all with String data type) and then selectively convert/process the fields based on row number, filename, or some other indicator in the data. I have used this method with some success on excel files that have almost the same format.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  4. #4
    Join Date
    Dec 2010
    Posts
    193

    Default

    Thanks both of you. So, it looks like need to explore the possibilities of Meta Data injection here to get a generic format.
    Sathish
    Back to Pentaho


    'Be the best Pearl in the ocean of wisdom'

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.