topic Re: [resolved] Pick single file from folder in Talend Studio

[resolved] Pick single file from folder

Anonymous — Mon, 15 Sep 2014 10:20:18 GMT

Hi,
I want to pick a single file from a folder which may have multiple files of same format. This file can be any file.
How to do so? tFileList iterates on files and loads all the files one after other. I don't want this. I only want to load a single file instead.

Re: [resolved] Pick single file from folder

Anonymous — Mon, 15 Sep 2014 10:26:12 GMT

I guess you need for some reason the tFileList component, otherwise your question is hard to understand because processing a single file is the default use case of the file processing components (like tFileInput* etc.).
You can set the file name in the tFileList as filter condition. Thats causes the tFileList to return exact this file.

Re: [resolved] Pick single file from folder

Anonymous — Mon, 15 Sep 2014 11:17:42 GMT

In tfileinput* we need to specify the file name. We can't use *.csv to pick a file.
I want to pick one file from the directory which may contain multiple files.
One File ---> TMap -----> tmysqlOutput
The don't know the file name but i know it is a csv file. (The folder can have multiple csv file at this time but i want to pick any one of them)

Re: [resolved] Pick single file from folder

Anonymous — Mon, 15 Sep 2014 11:35:11 GMT

hi,
you don't know the name but how to identify it (for the filter or regex) ?
regards
laurent

Re: [resolved] Pick single file from folder

Anonymous — Mon, 15 Sep 2014 11:43:51 GMT

I just need to pick any file in that folder.
The regex i would use is "*.csv" or "abc*.csv"

Re: [resolved] Pick single file from folder

Anonymous — Mon, 15 Sep 2014 12:39:42 GMT

If you want to control your no. of iterations then use tWaitForFile instead of tFileList.

Re: [resolved] Pick single file from folder

Anonymous — Mon, 15 Sep 2014 12:48:14 GMT

Thanks!
But won't it process all the files if multiple files are uploaded in the directory?

Re: [resolved] Pick single file from folder

Anonymous — Mon, 15 Sep 2014 13:33:48 GMT

Processing of files depends upon parameters you will define in component setting
please look below screenshot and put same parameters (as in your case only)

Re: [resolved] Pick single file from folder

Anonymous — Mon, 15 Sep 2014 14:59:29 GMT

just find a tricky way to do that
use the Talend variable NB_FILEtFileList_1 in a if condition after iteration on tFileList
if condition

NB_FILEtFileList_1==1

3 iterations (3 csv file) but read only one (the first one)
ps : just a System.out in my tJava

System.out.println(NB_FILEtFileList_1);

could be better to use a tWarn to log which file is iterate (current iteration)
hope it help
regards
laurent

Re: [resolved] Pick single file from folder

Anonymous — Tue, 16 Sep 2014 09:41:18 GMT

Thank you m.gajvani
Works fine now.

Re: [resolved] Pick single file from folder

Anonymous — Tue, 16 Sep 2014 10:10:47 GMT

just a point about 'tWaitForFile' as solution.
as background process (waiting for something), you have to listen to if it's still alive & stil wait for new file
regards
laurent