topic Re: [resolved] Is it possible to use tloop to loop from a start date thru end date? in Talend Studio

[resolved] Is it possible to use tloop to loop from a start date thru end date?

Anonymous — Sat, 16 Nov 2024 13:03:40 GMT

Hi,
I need to run a trunjob component setting up a context variable to a date - from 1/1/2010 thru 1/31/2010.
Is it possible to use the tloop component ot set the start date and loop by one day until end date is reached?
If not how could I achieve this ?
Thanks in advance.

Re: [resolved] Is it possible to use tloop to loop from a start date thru end date?

Anonymous — Thu, 03 Mar 2011 06:31:20 GMT

Hello
Set two context variables, start date and end date, use TalendDate.diffDate(Date date1, Date date2) to get the time difference, set this time difference to the 'To' field of tLoop component.
Best regards
Shong

Re: [resolved] Is it possible to use tloop to loop from a start date thru end date?

Anonymous — Mon, 07 Mar 2011 19:05:37 GMT

Hi Shong,
IO am still having issues setting this up. I have set up global var - start_date ("2009-01-01" ) and end_date("2009-12-31") but I cannot seem to get the tloop working correctly.
I have included screen shot of what I have.
Can you provide more detail?
Thanks

Re: [resolved] Is it possible to use tloop to loop from a start date thru end date?

Anonymous — Tue, 08 Mar 2011 02:48:07 GMT

Hi
As I said, you need use TalendDate.diffDate(Date date1, Date date2) to get the time difference first. please see my screenshots.

java.util.Date start_date=TalendDate.parseDate("yyyy-MM-dd", (String)globalMap.get("start_date"));
java.util.Date end_date=TalendDate.parseDate("yyyy-MM-dd", (String)globalMap.get("end_date"));
long l=TalendDate.diffDate(end_date, start_date);
globalMap.put("iterate", l);

Best regards
Shong

Re: [resolved] Is it possible to use tloop to loop from a start date thru end date?

Anonymous — Wed, 09 Mar 2011 18:45:28 GMT

Thanks, Shong

Re: [resolved] Is it possible to use tloop to loop from a start date thru end date?

Anonymous — Thu, 12 Sep 2013 21:58:13 GMT

And you can get the date in your next component using

TalendDate.addDate(TalendDate.parseDate("yyyy-MM-dd", (String)globalMap.get("start_date")),+((Integer)globalMap.get("tLoop_1_CURRENT_VALUE")),"dd")

edit: I replace my question with the answer.

Re: [resolved] Is it possible to use tloop to loop from a start date thru end date?

Anonymous — Fri, 18 Apr 2014 04:33:45 GMT

Created variation of this using a "While" loop.

Re: [resolved] Is it possible to use tloop to loop from a start date thru end date?

Anonymous — Tue, 24 Jun 2014 18:11:13 GMT

Thanks everyone for your input. This really helped me !!

Re: [resolved] Is it possible to use tloop to loop from a start date thru end date?

Anonymous — Tue, 27 Jan 2015 02:25:35 GMT

I know this is an old thread. Could anyone help me with screenshots?
I am not able to see any screenshots in this thread.
I want to accomplish something similar. Check below thread
https://community.talend.com/t5/Design-and-Development/resolved-Iterate-over-different-dates-using-date-in-SQL-query/td-p/80070

Re: [resolved] Is it possible to use tloop to loop from a start date thru end date?

talendtester — Tue, 13 Dec 2016 23:56:16 GMT

Here are the links:
http://www.talendforge.org/forum/img/members/55233/132833_Screen%20Shot%202014-04-17%20at%208.31.57%20PM.png
http://www.talendforge.org/forum/img/members/55233/132833_Screen%20Shot%202014-04-17%20at%208.32.05%20PM.png
http://www.talendforge.org/forum/img/members/55233/132833_Screen%20Shot%202014-04-17%20at%208.32.12%20PM.png
http://www.talendforge.org/forum/img/members/55233/132833_Screen%20Shot%202014-04-17%20at%208.32.19%20PM.png