tFTP process date and autoincrement number of data(FileName) from source

Anonymous — Sun, 09 Dec 2018 11:19:44 GMT

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.

Re: tFTP process date and autoincrement number of data(FileName) from source

Anonymous — Sun, 09 Dec 2018 16:38:52 GMT

Anyone?

topic tFTP process date and autoincrement number of data(FileName) from source in Talend Studio

tFTP process date and autoincrement number of data(FileName) from source

Re: tFTP process date and autoincrement number of data(FileName) from source