Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Help with extracting data from multiple files

  1. #1
    Join Date
    Oct 2013
    Posts
    3

    Default Help with extracting data from multiple files

    Hello

    I am trying to create a transformation that will extract data from multiple files and upload to a database. On the database, I have a table with 2 fields containing a source name and the file path. I need to extract the filepath from the records and pass the information to a step to extract the data and upload to a result table. I am able to do it for a single record but am not able to do it for multiple records. Is there a way to implement a loop to read the records and extract the data.

    Thanks in advance.

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

    Default

    Use a transformation and change advanced setting to execute for each row.
    Basically you pass your path names one by one to the transformation and within that transformation you manipulate/use your path name.
    -- Mick --

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.