how can i split the column?

[#1]

I have excel file with column QTR which contains all quarters but when i am loading into the qvw, I want that to be in each quarter in different column.

like below image in final qvd file

[ramoncova06]

you should not split that data that way, instead use a pivot table and drag drop you quarter field to the top

[MarcoWedel]

Hi,

you could load the quarters like:

tabQuarters:
LOAD *,
    Dual(Quarter_txt,MakeDate(Right(Quarter_txt,4),Mid(Quarter_txt,2,1)*3-2)) as Quarter
INLINE [
    Quarter_txt
    Q1 2015
    Q2 2015
    Q3 2015
    Q4 2015
    Q1 2016
    Q2 2016
    Q3 2016
    Q4 2016
];

and use in pivot tables as already suggested.

hope this helps

regards

Marco

[MarcoWedel]

Hi,

one example:

hope this helps

regards

Marco

[#5]

Hi Marco,

Could you pleases share the qvw file as I am unable to repro the same

Thanks

[MarcoWedel]

Already attached,  please try again.

Regards

Marco

[sasiparupudi1]

[#8]

to Sasidhar,

how can we achieve it?

[sasiparupudi1]

Hi

The field can be split as follows and rest is dependent on how you want your data to look like

  LOAD  

       SubField(Quarter_txt,' ',1) as Quarter,

              SubField(Quarter_txt,' ',2) as Year

    INLINE [ 

        Quarter_txt 

        Q1 2015 

        Q2 2015 

        Q3 2015 

        Q4 2015 

        Q1 2016 

        Q2 2016 

        Q3 2016 

        Q4 2016 

    ];