Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Loop through file names

  1. #1
    Join Date
    Feb 2016
    Posts
    22

    Default Loop through file names

    Hi Team,

    I have 3 csv files in a folder to be loaded into 3 respective tables based on the file names. I have looked for "loop" in kettle for its solution and i see that Job and Transformation both have an option as "Execute for every input row" but not able to get file names from one job / transformation to the another job / transformation.

    Can you please help with what all components and in what sequence I can use to achieve the solution.

    Regards.. Jawed

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Get-File-Names can pick up your filenames from the folder.
    Copy-Rows-To-Result can queue the filenames for use in a second transformation's settings.
    In the second transformation, enable "Copy previous results to parameters?" and fill out the Parameters tab.
    It's easy if your input files share the same field layout, and your output tables, too.
    So long, and thanks for all the fish.

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.