How to filter time period to( month year) and quarter year

[vinod2086]

Hi All,

i have a Time Period(YYYYMM) in my data in that i want to filter Time Period into

"Month Year" like Jan2017..etc and

"Quarter Year" like Q12017,Q22017..etc

please help on this

Thanks in advance.

[its_anandrjs]

Try with this

Load

Period,

Date(Period,'MMM-YYYY') as [Month Year]

'Q' & ceil(Month(Period)/3)&Year(Period) as [Quarter Year]

From Source;

[jayshrinipurte]

Hi V Kumar...

Load *,

Month&''&year as MonthYear,

'Q' & ceil(Month(TRANDATE)/3)&year as [Quarter Year];

LOAD

year(TRANDATE) as year,

Month(TRANDATE) as MonthYear

[its_anandrjs]

Check the attached hope you are looking for this.

Output