Highlighted
One Star

How to set a wildcard for file name of tFileinputDelimited

Hi,
Please tell me my question.
Has Talend a wildcard such as VBA's "*" or oracle's "%"?
What I wanna do is like following.
e.g
tFileinputDelimited FIleName in job : "com/sale*.csv"

Thanks!
Regards,
3 REPLIES
Employee

Re: How to set a wildcard for file name of tFileinputDelimited

Hi Yuya,
You would have to use a tFileList component to return a list of files matching your wildcard, and then in the tFileInputDelimited use the file name returned by the tFileList to use it as an input.
You can drag and drop the tFileList component in your job design and press F1 if you want more information about it.
One Star

Re: How to set a wildcard for file name of tFileinputDelimited

Hi vgalopin,
Thank you for your replay.
but I have make other error.
When I use a tFileList component for xls files in a directory to return this file name to tFileInputExcel component's file name.
Although this component could not find the file I want.
Following are error scripts:


Why this component could not find the file?
And It could find that when file type in a directory was "csv".
Could you please tell me about this case.
Thanks!
Regards,
Community Manager

Re: How to set a wildcard for file name of tFileinputDelimited

Hi
How do you set the file mark? it should be something like "*.csv" or "*.xls"
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business