Five Stars

Date wise Calculation

Hello,

 

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!

Regards

Siddheshkpi format.png

3 REPLIES
Moderator

Re: Date wise Calculation

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

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