Hi All
Please help me on this how to do YTD(Year-To_Date) by using DataStage
Advanced Thank u
Regards
srini
Year to date(YTD)
Moderators: chulett, rschirm, roy
Re: Year to date(YTD)
Do you want to convert a DATE TO YEAR FORMAT , I mean 25-08-2006 and just want to extract 2006?ysrini9 wrote:Hi All
Please help me on this how to do YTD(Year-To_Date) by using DataStage
Advanced Thank u
Regards
srini
Then try this
Oconv(Iconv(Arg1,"D-DMY"), "D-Y")
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Year to date(YTD)
Hiray.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? ...
it is a summing of values for all dates in the current year up to today.
Regards
srini
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.