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

Announcements
Join us in Bucharest on Sept 18th 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.