Using prefix to load documents in a certain job

Lawlo — Fri, 15 Nov 2024 21:04:50 GMT

Hello,

First of all, i am sorry about my english, i will try to do my best to make sure you all understand :

I want to create a job in talend, this job have to load some specifics files in "tFileInputDelimited" or in "tFileInputExcel".

I have a specific folder where all my files will be placed.

(For exemple in the same folder, we will find :
- AC-XXXXXXX.csv or TR-XXXXXXX.csv etc..)

I wanna check the prefix of all files name in the folder and when the job start, use every file that begins with AC in the same job.

I was hoping than something like "AC"+*.csv was working but can't find a proper way to do it.

Hope i did explain my issue well.

Thanks for helping!

Re: Using prefix to load documents in a certain job

Shicong_Hong — Tue, 06 Feb 2024 15:15:18 GMT

You just need to use a tFileList to iterate all files and set the file mask like this: "AC*.csv".