Looping every month

Karuetl — Tue, 12 Nov 2019 18:10:37 GMT

I want to loop every month with start_date as start date of the month and end_Date as End date of the month

Once loaded then it has to go previous month dates and keep going back so that i can load every month data into the table

Re: Looping every month

Anonymous — Tue, 12 Nov 2019 18:20:33 GMT

Hi,

If you want to create new records based on two date values, you can achieve them in following steps.

a) Identify the number of records by calculating the difference between start date and end date using TalendDate.diffDate function and store the value to a context variable.

b) Use add date function TalendDate.addDate(start_date,i,"DD") where i need to iterate from 0 to context variable value. You can also use tRowgnerator to create these dummy records.

Try it out first and if you are stuck with logic, you can come back and I will be happy to help 🙂 Please add your job screen shots with error area details if you are having any issues.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

topic Re: Looping every month in Talend Studio

Looping every month

Re: Looping every month