I have some folders with .txt files. I wan't to read the file and insert data into database table. But I don't wan't to read files the from some folders, like eg: if the folders has names lke test_rts,test2_old and 123456, I want to pick the files from 123456.
There are many folders, I want to pick the files from folder, which is named with numbered like 234567,986432 and folder name length should be 6 .
Hi, File is picked up from the path provided with the filter in the expression. If your folder name is dynamic and you want to iterate on folders then you need to identify a way to get the folder names may be something similar to below tFixedFlow-->Iterate-->tFileList-->tFileInput-->youroutput... Whether the metadata is same for all the files? If metadata is different, then you need to create different flows based on if clause and read those files based on certain condition. Thanks Vaibha
Hi, My folder structure is like this d:/temp/ under above directory there are many sub-directories like AB,CD,EF d:/temp/AB d:/temp/CD d:/temp/EF under above directory there is a common folder named 'fest' d:/temp/AB/fest d:/temp/CD/fest d:/temp/EF/fest under above directory there are folders named like this '123456','234567','987654_gfds' d:/temp/AB/fest/123456 d:/temp/AB/fest/234567 d:/temp/AB/fest/987654_gfds There are .txt files from above directory, but I want to pick up from the folders '123456','234567'. I want to pick up .txt files from 6 digit folder. Please do needful help.