Date wise Calculation

[Anonymous]

Hello,

I have a static data originates from  oracle database.  Desire structure will be following ways

 i know sql query using sysdate so it will be take care @time of live environment n talend also .  but previous  2 years static data ,i want to load day  wise calculation with help of talend component or query  .it must  be look like Above image structure  .

. I am not sure how to do this calculation day wise using talend component  .please help out for problem 

Thanking You!

Regards

Siddhesh

[Anonymous]

Hello,

What does your wise calculation look like? Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[Anonymous]

HEY, I have oracle dump which have 2 years data. i want to do calculation on day level .so how we can do it dynamically in talend .

For Example:

Kpi id  Kpi Desc Date               last week volume   current week

1          B2B        2/1/2016        100                            50

2          C2C        3/1/2016        500                            200

can you tell me any possibility?

[Anonymous]

formula used for last week  formula  :TRUNC(SYSDATE) - INTERVAL '13' DAY

                           current week formula :TRUNC(SYSDATE) - INTERVAL '7' DAY

but unable to load static two year data ..