Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Following is my Calendar from which I want Month Name.How to Retrive Month Name from It.
left join (April)
LOAD * INLINE [
MONTH_NUM,Month
4, Apr
5, May
6, Jun
7, Jul
8, Aug
9, Sep
10, Oct
11, Nov
12, Dec
1, Jan
2, Feb
3, Mar
];
GDP_1:
load *,
MakeDate(Year,MONTH_NUM,1) as GDPDT
//'Q' & Ceil(NUM(MONTH_NUM)) AS GDPQuarter,
//'Q' & ceil(month(MakeDate(Year, MONTH_NUM,1))/3) as [GDPDT Quarter]
Resident April;
drop table April;
GDP_Final:
Load *,
//Year(GDPDT) AS [GDP Year],
right(yearname(GDPDT,0,4),4) as [GDP FYear],
//Month(GDPDT) AS [GDP Month],
if(num(month(GDPDT))<=3,(num(month(GDPDT))+9),(num(month(GDPDT))-3)) AS [GDP MonthNum],
Day(GDPDT) AS [GDP Day],
'Q' & Ceil(NUM(if(num(month(GDPDT))<=3,(num(month(GDPDT))+9),(num(month(GDPDT))-3)))/3) AS [GDPDT Quarter]
RESIDENT GDP_1;
DROP TABLE GDP_1;
Please post sample Application
The Script I have wrote for calendar I already attached,can you help me out from that cause I have not Application right now..
So how to Get Month Name from Above Script...?
To get month name try this out:
Date (GDPDT,'MMM') as MonthName
Isnt it simply selecting the field in your load statement? or please post a sample
GDP_1:
load *,
MakeDate(Year,MONTH_NUM,1) as GDPDT
Month,
//'Q' & Ceil(NUM(MONTH_NUM)) AS GDPQuarter,
//'Q' & ceil(month(MakeDate(Year, MONTH_NUM,1))/3) as [GDPDT Quarter]
Resident April;
drop table April;
GDP_Final:
Load *,
//Year(GDPDT) AS [GDP Year],
right(yearname(GDPDT,0,4),4) as [GDP FYear],
Month,
//Month(GDPDT) AS [GDP Month],
if(num(month(GDPDT))<=3,(num(month(GDPDT))+9),(num(month(GDPDT))-3)) AS [GDP MonthNum],
Day(GDPDT) AS [GDP Day],
'Q' & Ceil(NUM(if(num(month(GDPDT))<=3,(num(month(GDPDT))+9),(num(month(GDPDT))-3)))/3) AS [GDPDT Quarter]
RESIDENT GDP_1;
DROP TABLE GDP_1;
Hi Thiago I got output as Apr,May,Jun....so on but My Date is of Two Years i.e. 2017 and 2018 and I want Output as Apr 2017,May 2017...Apr 2018,May 2018...so on
So how it is Possible...?
Thanks in Advanced..
Yes, it's.
Date (GDPDT,'MMM') & ' ' & Year (GDPDT) as MonthYear
Date (GDPDT,'MMM YYYY') as MonthYear
Hi Sasidhar it is working but is gives output like 01/03/2017,01/02/2017 but I want output as Apr 2017,May 2017..