You are not logged in.

#1 2011-09-22 11:57:16

yuya
Guest

How to set a wildcard for file name of tFileinputDelimited

Tags: [development]

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,

#2 2011-09-22 16:31:19

vgalopin
Talend Team


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.


Vincent Galopin
US Pre-Sales Consultant
Talend US

Offline

#3 2011-09-27 08:51:07

yuya
Guest

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:

[Exception in component tFileList_1
java.lang.RuntimeException: No file found in directory //Server's IP/TEST
    at online_sales_job.ebs_0_1.SAMPLE.tFileList_1Process(SAMPLE.java:1592)
    at online_sales_job.ebs_0_1.SAMPLE.runJobInTOS(SAMPLE.java:1904)
    at online_sales_job.ebs_0_1.SAMPLE.main(SAMPLE.java:1772)]

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,

#4 2011-09-27 09:07:31

shong
Talend Team


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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy