read input file with dynamic file name

[vidya821]

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 · Accepted solution]

Have a look to tFileList

[Irshad1]

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]

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

[Anonymous]

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