retracted

Tue, 27 Nov 2012 02:52:29 GMT

retracted

Re: Please help with creating "quarter" and "annual" loads

nirav_bhimani — Sat, 05 Jan 2013 05:50:17 GMT

Hi,

Please explain in detail.

Regards,

Nirav Bhimani

er_mohit — Sat, 05 Jan 2013 07:47:20 GMT

hiiii. , DATE is my field like this 28-9-2008 to 21-9-2012.

so,

you can try this in script here

1stly you load your table then do this.

load *,

separate day:

day(DATE) AS Day,

separate month:

Month(DATE)AS Month,

for finanacial:

yeARNAME(DATE,0,2) as FinancialYear,

for quarter:

'Q' & Ceil(Month(DATE)/3) as Quarter,

Dual(Year(DATE) & '-Q' & Ceil(Month(DATE)/3), Year(DATE) & Ceil(Month(DATE)/3)) as YearQtr,

for annual load :

year(DATE) as Year;

hope it helps you