topic Re: TfileList catches one file only in Talend Studio

TfileList catches one file only

_AnonymousUser — Wed, 19 Mar 2014 10:27:24 GMT

Hi,
I tried to display some results from several files in a directory. I use TFileList, and 2 tFileInputDelimited which are both linked to TFileList. I don't know why but at the end of the processing my results are lugged from just one of the 6 files I want. It appaears that there are results from the list file of the directory.
Can you help please?

Re: TfileList catches one file only

Anonymous — Wed, 19 Mar 2014 13:38:31 GMT

-Make sure file mask as "*.csv" in tFileList component
-Make sure connection type is Iterate
- also check the file name in tFileInputDelimited component, which will be dynamic like
((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))
so it will iterate each file from the directory to give an input for tFileInputDelimited component

Re: TfileList catches one file only

Anonymous — Thu, 20 Mar 2014 04:11:07 GMT

Hi,
In addition, what's your output? file or DB? You should checkout "Append" option in tfileoutputdelimited to get all files.
Please have a look at related forum https://community.talend.com/t5/Design-and-Development/resolved-looping-of-tfilelist/td-p/89356.
Best regards
Sabrina

Re: TfileList catches one file only

Anonymous — Thu, 27 Mar 2014 14:36:32 GMT

Hi All,
Can we process different file types like ".csv,.txt,.xls,.xlsx" at a time?

Re: TfileList catches one file only

Anonymous — Thu, 27 Mar 2014 17:19:10 GMT

You should be able to read them all in with a tFileList and putting "*.*" in the Filemask field.

Re: TfileList catches one file only

Anonymous — Fri, 28 Mar 2014 03:02:37 GMT

Hi,

Can we process different file types like ".csv,.txt,.xls,.xlsx" at a time?

.
You can design different subjobs then make "Parallelize" for them. Such as:

tfilelist-->tfileinputdelimited-->tlogrow
tParallelize----
tfilelist-->tfileinputexcel-->tlogrow
Note: tParallelize component is only available in Talend Enterprise Subscription Version.

Best regards
Sabrina