how to get 7 days data then again next

[Anonymous]

hello ,

In my scenario i have a table which can contain 10 k rows data , i want to perform operation to get total of  7 days cost  from the start date then again next 7 days data.

input table like this:- 

total	date
5000	2019-02-21
6000	2019-02-23
1000	2019-02-25
100	2019-02-27
9000	2019-03-02
7000	2019-03-07

and i want output this type:-

start date                          End Date                                 total

2019-02-21                     2019-02-25                              10000

2019-02-26                     2019-03-01                              20000

2019-03-02                     2019-03-08                              10000

Thanks in advance,

Regards,

Vitspl,

[Anonymous]

Hi,

    Since start date is the driving data in this case, could you please advise on what basis are you identifying the start date values? I could not see any correlation between input data and the output start date values in your example. Could you please redefine your example with better sample data as the current data is scattered in calendar as shown below.

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 🙂

[Anonymous]

hello @nthampi  

thanks for reply,

this is my input data, and i want to get totals of every 7 days from the start date.  

thanks,

Regards,

Manish