topic how to append a data to the existing csv file that changes its name every time? in Talend Studio

how to append a data to the existing csv file that changes its name every time?

Anonymous — Sat, 16 Nov 2024 05:19:29 GMT

Hi,

I have a job that loops through and produces a csv file after every 5000 records. The csv file gets its name by the current timestamp("Talend/workspace/stock_"+TalendDate.formatDate("yyyyMMdd_hhmmss",TalendDate.getCurrentDate()) +".csv"). I need to append the data to the same file after every 5000 records until the record limit has reached.

But, the issue is that it creates a new csv file every time because of the its name which uses current time stamp as its name. If I don't use the current time stamp as a csv file name then it does append the data to the same csv. But its not enogh in my case.

Any solutions?

Thanks

Re: how to append a data to the existing csv file that changes its name every time?

Anonymous — Wed, 10 Jul 2019 13:19:14 GMT

Sloution not required anymore. sorted

Re: how to append a data to the existing csv file that changes its name every time?

lennelei — Wed, 10 Jul 2019 14:27:34 GMT

Good news! By the way, you can use
TalendDate.getDate("yyyyMMdd_hhmmss")
To get the current date in a given format.