topic Re: Date wise Calculation in Talend Studio

Date wise Calculation

Anonymous — Sat, 16 Nov 2024 08:46:37 GMT

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

Re: Date wise Calculation

Anonymous — Fri, 02 Feb 2018 06:48:16 GMT

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

Re: Date wise Calculation

Anonymous — Fri, 02 Feb 2018 08:34:28 GMT

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?

Re: Date wise Calculation

Anonymous — Fri, 02 Feb 2018 09:32:14 GMT

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