Year to date(YTD)

ysrini9 · Post by **ysrini9** » Mon Aug 21, 2006 1:49 am

Hi All

Please help me on this how to do YTD(Year-To_Date) by using DataStage

Advanced Thank u

Regards
srini

dprasanth · Post by **dprasanth** » Mon Aug 21, 2006 2:22 am

ysrini9 wrote:Hi All

Please help me on this how to do YTD(Year-To_Date) by using DataStage

Advanced Thank u

Regards
srini

Do you want to convert a DATE TO YEAR FORMAT , I mean 25-08-2006 and just want to extract 2006?
Then try this
Oconv(Iconv(Arg1,"D-DMY"), "D-Y")

kumar_s · Post by **kumar_s** » Mon Aug 21, 2006 2:33 am

What is the input and what is the desired output?
If the input is given as 2006, do you want to convert it as 01-01-2006 or 31-12-2006?

ray.wurlod · Post by **ray.wurlod** » Mon Aug 21, 2006 9:23 am

"Year to date" might be a transformation, or it might be a summing of values for all dates in the current year up to today. Which are you trying to do?

ysrini9 · Post by **ysrini9** » Wed Aug 23, 2006 11:50 pm

ray.wurlod wrote:"Year to date" might be a transformation, or it might be a summing of values for all dates in the current year up to today. Which are you trying to do? ...

Hi

it is a summing of values for all dates in the current year up to today.

Regards
srini

pigpen · Post by **pigpen** » Thu Aug 24, 2006 12:41 am

Do you mean something like this?
Oconv(Date(), "DJ")

ray.wurlod · Post by **ray.wurlod** » Thu Aug 24, 2006 1:10 am

Not in a routine.

For preference use SQL.

If you must use a DataStage job, use a selection filter (or a constraint in a Transformer stage) and aggregate the sum either in a stage variable or in an Aggregator stage downstream of the Transformer stage.

kumar_s · Post by **kumar_s** » Thu Aug 24, 2006 1:14 am

ysrini9 - Why do you want to create duplicate post. You other post "YTD Problem" will also lead to the same sort of solution.

DSXchange

Year to date(YTD)

Year to date(YTD)

Re: Year to date(YTD)

Year to date(YTD)