Convert value to Years

halpavan2 · Post by **halpavan2** » Fri Dec 09, 2011 5:09 am

Hello All,

I want to convert the value to years by using (365.25 days = 1 year).

Can any one help me how this can be done in datastage parallel jobs.

Thanks
Pavan

ray.wurlod · Post by **ray.wurlod** » Fri Dec 09, 2011 5:19 am

What value? What unit of measurement?

halpavan2 · Post by **halpavan2** » Fri Dec 09, 2011 5:34 am

i am getting the value from source(Integer) like this

194
2037
20438
32599

want to convert this to years

manoj_23sakthi · Post by **manoj_23sakthi** » Fri Dec 09, 2011 6:05 am

Hi ,
By using transformer u can get this ..
But i need more clarification on this .

JOB:
Source ---->Trans------->Target

source:
---------
column1
194
2037
20438
32599

Transformer:
--------------
Stage variable: column1/365.25
Column1 : If floor(Stage variable) < 1 then 1 else floor(Stage variable)

Target:
u can get that..

let me know if its Wrong

Thanks
Manoj

halpavan2 · Post by **halpavan2** » Fri Dec 09, 2011 7:23 am

Thanks for your reply....

in my source link data is coming form days say from (0-1000)...i want this to converted this to years by using by using (365.25 days = 1 year).

I have tried with above example with 10 records from 1 to 10...anf all the records giving me as 1.

My doubt here was how 1 day will be giving as 1 year afetr using the above logic...

chulett · Post by **chulett** » Fri Dec 09, 2011 7:27 am

You need to decide where to round a fractional year up or down and then adjust the code accordingly.