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
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.
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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks