Solved: Row to Column - Qlik Community

Report Inappropriate Content · ‎2016-02-12

Hi,

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

Thank you

MayilVahanan · ‎2016-02-12

HI

Try like this

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

ID

1

2

"3,4,5"

6

"7,8"

];

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

MayilVahanan · ‎2016-02-12

HI

Try like this

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

ID

1

2

"3,4,5"

6

"7,8"

];

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

awhitfield · ‎2016-02-12

Hi Hans,

try this:

Tabelle:

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

ID

1

2

"3,4,5"

6

"7,8"

];

Andy

Row to Column