topic Re: read input file with dynamic file name in Talend Studio

read input file with dynamic file name

vidya821 — Tue, 12 Sep 2017 15:24:15 GMT

Hi All,

I have a requirement where i need to read the input file, however the input file can have dynamic name

File name pattern is (Static + dynamic)

e.g

1) INPUT_FILE_123456.txt

2) INPUT_FILE_789548.txt

This pattern is applicable for delimited and excel file

Please suggest.

Thanks

TRF — Tue, 12 Sep 2017 15:28:57 GMT

Have a look to tFileList

Irshad1 — Tue, 12 Sep 2017 15:41:18 GMT

Hello

If your file structure is same but are in n numbers with different names you can read it using tFileList. for example you're having below files:

XYZ_09122017.csv

XYZ_09112017.csv

XYZ_09102017.csv

XYZ_09092017.csv

You can give the pattern as XYZ_*.csv so that it will search the files in the path provided.

Thanks!

TRF — Tue, 12 Sep 2017 20:32:31 GMT

Did it help you?
If it did, feel free to mark the question as solved (Kudos also accepted).

Anonymous — Wed, 13 Sep 2017 08:45:03 GMT

Hello,

Is there any update for your issue? Here is also a scenario about:TalendHelpCenter: Iterating on a file directory.

Hope it will help.

Best regards

Sabrina