Split data as columns - Quarters

[#1]

Hi Team,

I have a column Quarters which has data like Q1 2015,Q2 2016,Q3 2017 and so on.

i want this to be broken down into columns as Q1, Q2, Q3 and Q4

Please provide your suggestions

Thanks,

SV

[maxgro · Accepted solution]

do you want (script?) the "Q1 2015" value  in columns Q1?

load

     Quarters,

     if(left(Quarters,2)='Q1', Quarters) as Q1,

     if(left(Quarters,2)='Q2', Quarters) as Q2,

     ......

but I don't understand the reason

[MarcoWedel]

Hi,

do you really want to create separate columns for the quarters?

Or just the quarter information extracted in one column and use this as horicontal dimension in a pivot table?

The latter could be achieved like:

LOAD Left(Quarters, 2) as Quarter
FROM yoursource;

maybe this helps also:

how can i split the column?

regards

Marco