One Star

iterate through subdirectories

Hi,
I have a requirement to get various file properties from numerous files within numerous directories.
I can get all of this information from a single directory using the tFileList component. However, when I try to use the tFileList to iterate through the parent directory the job just hangs and eventually crashes. I have also tried multiple tFileList components linked together, the idea being the first would iterate through the parent directory, using filelist type of directories, then connect this to the 2nd tFileList using the directory path - (String)globalMap.get("tFileList_1_DIR") - same outcome.
What am I doing wrong? Any suggestions?
directory structure is :
xxx/20130101/xxx.xxx
xxx/20130102/xxx.xxx
1 REPLY
One Star

Re: iterate through subdirectories

I just created a simple test job that seems to work.
tFileList -> tFileProperties -> tLogRow
In tFileList, set FileList Type to "Both" in the drop down. Check the box labeled "Includes subdirectories". Set the directory to the parent directory you want to use.
In tFileProperties, set File to "((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))"
In tLogRow, set Mode to "Table".
Run the job.
Hope this helps
Wayne