Seven Stars

read input file with dynamic file name

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Twelve Stars TRF
Twelve Stars

Re: read input file with dynamic file name

Have a look to tFileList

TRF
4 REPLIES
Highlighted
Twelve Stars TRF
Twelve Stars

Re: read input file with dynamic file name

Have a look to tFileList

TRF
Six Stars

Re: read input file with dynamic file name

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!

Twelve Stars TRF
Twelve Stars

Re: read input file with dynamic file name

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

TRF
Moderator

Re: read input file with dynamic file name

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.