Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Not applicable

display separate columns in the table

NAMETIMEMONTH
raju11:30jan,feb ,march
suresh12:30april,may,june
rajesh1:30july,aug,sept
mahesh10:30oct,nov,dec

Data is mentioned in the above table. my requirement is to display separate month columns like jan

                                                                                                                                           feb ........  in output table . plz send me solution.

thanks... 

Tags (1)
8 Replies
xufei123
Valued Contributor

Re: display separate columns in the table

Not applicable

Re: display separate columns in the table

THE .QVW FILE NOT OPEN IN MY PERSONAL PC SO PLZ EXPLAIN  ME

THANKS

satyadev_j
Valued Contributor

Re: display separate columns in the table

Hi,

You may have to use loop to separate month in each row.

FOR i = 1 to 3

Table:

LOAD

     Name,

     Time,

     SubField(Month, ',', $(i)) as Month

INLINE [

    Name, Time, Month

    raju, 11:30, "jan,feb,march"

    suresh, 12:30, "april,may,june"

    rajesh, 1:30, "july,aug,sept"

    mahesh, 10:30, "oct,nov,dec"

];

NEXT

xufei123
Valued Contributor

Re: display separate columns in the table

My answer is the same with Satyadev below.

parthiband
Contributor

Re: display separate columns in the table

Hi Sathyadev,

For condition is not needed i guess.

Simple subfield will work fine

Table:

LOAD Name,

     Time,

     SubField(Month, ',') as Month;

LOAD * INLINE [

    Name, Time, Month

    raju, 11:30, "jan,feb,march"

    suresh, 12:30, "april,may,june"

    rajesh, 1:30, "july,aug,sept"

    mahesh, 10:30, "oct,nov,dec"

];

Thanks

Not applicable

Re: display separate columns in the table

thanks durairaj

Highlighted
parthiband
Contributor

Re: display separate columns in the table

You're welcome!!

Try closing the discussion by choosing the right answer, which might be useful in future for the one, who comes in and searches for the same question

Thanks

MVP
MVP

Re: display separate columns in the table

Hi,

Try like this

Table:

LOAD

     Name,

     Time,

     SubField(Month, ',') as Month

INLINE [

    Name, Time, Month

    raju, 11:30, "jan,feb,march"

    suresh, 12:30, "april,may,june"

    rajesh, 1:30, "july,aug,sept"

    mahesh, 10:30, "oct,nov,dec"

];

Regards,

Jagan.