I have a scenario that I need to download and process a full file load to the database and get the latest file monthly which is the date is 18th. And if ever that I need to process a full file for Novemeber 12 I need to get the October 18th file since there's no November 18 data yet. How can I determine that using MySQL Query on tMySQLInput?
SELECT DATE_FORMAT(MAX(log_date) ,'%b%d-*') ftp_full from TBL_NAMEwhere DAY(log_date)>= 16 ;
2. The file name on the database is like this: FNameMonthDay-(incremental number from the source).
I already determine on how can I get the MonthDay which is the abbreviated month and day is like this: FNameApr18
But, I don't know how can I make the incremental number after -, the data is like: FNameApr18-111 the Next month it will be FnameMay18-112, but I don't know how can I do that on talend.
Below is my component screenshot.
Join us live for a sneak peek!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.