Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

TfileList catches one file only

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?
Labels (2)
5 Replies
Anonymous
Not applicable

-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
Anonymous
Not applicable

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
Anonymous
Not applicable

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

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

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