Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Spoon Problem by reading files

  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Default Spoon Problem by reading files

    Hello,
    I have a problem by reading files in a loop with "copy rows to result".
    I have one variable with the Directory Path:
    RootDirectory=D:\BSS\DMM_STREAMING\streaming
    and another variable with the Subdirectories
    SubDirectories=IPANEMA LEBLON BLOODY MARY ACAPULCO CANCUN.
    Now I would like to read all files in a loop in the given Subdirctories, given in the
    variable "SubDirectories". These Directorys can be variable. That means, that there can be
    up to 20 Directorys, or only 5 Directorys.
    In the Subdirectories could be one or more files, which I will read and process.
    It will be nice if you can help me.

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

    Default

    Hi.
    Have you tried using the "Get Files" step?
    Once you have those file names you can save them ina file and you can create a job that executes every row in a loop:
    http://www.cloud2land.com/2011/06/pe...ultiple-files/

    Hope it helps.
    Mick

  3. #3
    Join Date
    Jun 2011
    Posts
    2

    Default

    Thanks a lot !!!
    Now it is working !!!

    best regards

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.