Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Row to Column

Hi,

how I can change the string value "3,4,5" to one column?

Thank you

1 Solution

Accepted Solutions

Re: Row to Column

HI

Try like this

LOAD SubField(ID, ',') AS ID INLINE [

    ID

    1

    2

    "3,4,5"

    6

    "7,8"

];

2 Replies

Re: Row to Column

HI

Try like this

LOAD SubField(ID, ',') AS ID INLINE [

    ID

    1

    2

    "3,4,5"

    6

    "7,8"

];

awhitfield
Esteemed Contributor

Re: Row to Column

Hi Hans,

try this:

Tabelle:

Load SubField(ID, ',') as ID INLINE [

    ID

    1

    2

    "3,4,5"

    6

    "7,8"

];

Andy

Community Browser