Date wise Calculation

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

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog