Five Stars

Date wise Calculation



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

kpi format.png



 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!


Siddheshkpi format.png


Re: Date wise Calculation


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

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Date wise Calculation

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?

Five Stars

Re: Date wise Calculation

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 ..