Create 12 columns for months by writing single case statement?
- 1 Answers
- 4687 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / naresh
To create 12 columns for months by single case statement :-
Step-1: Create one derived column and name it as 'months'.
Step-2:In Derived Expression use the below case statement and click on ok -
case
when extract(month,DATE_Column)=1 then 'JAN'
when extract(month,DATE_Column)=2 then 'FEB'
when extract(month,DATE_Column)=3 then 'MAR'
when extract(month,DATE_Column)=4 then 'APR'
when extract(month,DATE_Column)=5 then 'MAY'
when extract(month,DATE_Column)=6 then 'JUN'
when extract(month,DATE_Column)=7 then 'JUL'
when extract(month,DATE_Column)=8 then 'AUG'
when extract(month,DATE_Column)=9 then 'SEP'
when extract(month,DATE_Column)=10 then 'OCT'
when extract(month,DATE_Column)=11 then 'NOV'
when extract(month,DATE_Column)=12 then 'DEC'
end
Step-3: Click on derived Column 'Months' and go to 'Structure' tab in File Menu and then click and 'Pivot list to Cross tab '
Step-4: Run and check the report.
Thats it ..
| Is This Answer Correct ? | 1 Yes | 0 No |
Why do we create shortcuts in framework manager
What is Star schema group?
when can i use the STAR Schema and SNOWFLAKE Scgena
we have package it contain Query subject (123456). If u generate report with 6 query subject error will occure how to resolve this problem
how many types of keys are there i.e primary key and foreign key etc..?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
WHAT ARE THE TYPES OF LIST REPORTS?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Can anyone tell me the step by step process how to connect cognos to oracle?
what is field set? what is the query calculation and layout calculation?
What is the use of 'individual data source' option while using filter in query studio?
Teradata 
