Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Reading flat file with a dynamic file name in talend

Hi Guys,
Was wondering if you could assist.
I am trying to read a flat file that has a dynamic file name; dynamic in a sense that the first part of the file name remains static but the last part(date) changes daily i.e: FADEAL_20110329. I was going to use the tInputFilePositional function, but that's as far as I got.
Please Please Please help if you can...
Thanking yall in advance 0683p000009MACn.png
Thanks and Regards,
Panik
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

In the input field where you specify the filename, you can use an arbitrary Java expression.
For example:
"c:/Path/To/Directory/FADEAL_" + TalendDate.formatDate ("yyyyMMdd", new java.util.Date())
This would create a timestamp of the current date.
Hope that helps.

View solution in original post

2 Replies
Anonymous
Not applicable
Author

In the input field where you specify the filename, you can use an arbitrary Java expression.
For example:
"c:/Path/To/Directory/FADEAL_" + TalendDate.formatDate ("yyyyMMdd", new java.util.Date())
This would create a timestamp of the current date.
Hope that helps.
Anonymous
Not applicable
Author

Thank you very much aspiegel it works 0683p000009MACn.png
Much Appreciated.