regarding DSTRANSFORMERS
Moderators: chulett, rschirm, roy
regarding DSTRANSFORMERS
hi gurus,
my design is odbc---->transformer--->odbc.
i have i/p column hiredate.
its format is 1980-12-17.
iam defining column properties as MONTH.TO QUARTER('HIREDATE')
will i convert months into quarter, will i able to view the quarters.
am i going in the right way.plz gurus help me.
cheers;
saama
my design is odbc---->transformer--->odbc.
i have i/p column hiredate.
its format is 1980-12-17.
iam defining column properties as MONTH.TO QUARTER('HIREDATE')
will i convert months into quarter, will i able to view the quarters.
am i going in the right way.plz gurus help me.
cheers;
saama
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
If you check from the description of MONTH.TO.QUARTER Transform , you will find
Is that what you want?
Code: Select all
Converts string in MONTH.TAG format (YYYY-MM) to QUARTER.TAG format (YYYYQN).
Example: MONTH.TO.QUARTER("1993-02") => "1993Q1"
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
I guess this is more close to your requirement - TAG.TO.QUARTER
Code: Select all
Converts string in DATE.TAG format (YYYY-MM-DD) to QUARTER.TAG format (YYYYQN).
Example: TAG.TO.QUARTER("1993-02-14") => "1993Q2"
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Code: Select all
Converts string in DATE.TAG format (YYYY-MM-DD) to QUARTER.TAG format (YYYYQN).
Example: TAG.TO.QUARTER("1993-02-14") => "1993Q1"
![Wink :wink:](./images/smilies/icon_wink.gif)
Sam
Right, Thanks for pointing that out, Sam.us1aslam1us wrote:Feb falls in first quarter.Code: Select all
Converts string in DATE.TAG format (YYYY-MM-DD) to QUARTER.TAG format (YYYYQN). Example: TAG.TO.QUARTER("1993-02-14") => "1993Q1"
![]()
Sam
Looks like it is a documentation bug in this Transform's Description or sombody has modified its description in our company.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: regarding DSTRANSFORMERS
The quotes around the input column name are incorrect.Saama wrote:iam defining column properties as MONTH.TO QUARTER('HIREDATE')
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.