| Pivot [message #250953] |
Thu, 12 July 2007 00:38  |
vamsi88
Messages: 6
Registered: January 2007
|
Junior Member |
|
|
Hi,
I've data like this..
CASE_ID ACTION DT
1227626 Assigned case to FixerGroup 17.05.2007
1227626 Case Note 18.05.2007
1227626 Assigned case to FixerGroup 18.05.2007
1227626 Case Note 22.05.2007
1227626 Assigned case to FixerGroup 23.05.2007
1227626 Case Note 24.05.2007
1227626 Assigned case to FixerGroup 24.05.2007
1227626 Case Note 25.05.2007
Is there a way i can display my data like this:
CASE_ID DT_Received DT_Actioned
1227626 17.05.2007 18.05.2007
1227626 18.05.2007 22.05.2007
1227626 23.05.2007 24.05.2007
1227626 24.05.2007 25.05.2007
i.e where
Action ="Assigned case to FixerGroup" DT should become the DT_Received
and where
Action= "Case Note " DT should become the DT_Actioned
Thanks
Vamsi
|
|
|
|
|
|
|
|
| Re: Pivot [message #250966 is a reply to message #250953] |
Thu, 12 July 2007 01:33  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Put your title in the search field and you get your answer.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
