Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

balanandam
Contributor II

Convert Column to Rows

Hi All,

I have one requirement as below. I have sample data like

IMEI, contentype

1236548989,Message

1236548989,Audio

1236548989,Images

1236548987,Message

1236548987,Vedio

I need this to be converted as

IMEI, contentype

1236548989,Message,Audio,Images

1236548987,Message,Vedio

Pls. suggest.

Br, Balanandam

2 Replies

Re: Convert Column to Rows

Hi, this can be done  with Concat(), inscript needs a Group By clause:

LOAD

  IMEI,

  Concat(contentype, ',') as contentype

Resident/from...

Group by IMEI;


Edit: and maybe Concat(distinct contentype, ',') if you want to avoid repeated values.

jwjackso
Valued Contributor

Re: Convert Column to Rows

Check this article on a generic load (reverse crosstable)  https://qlikies.wordpress.com/2016/02/22/the-generic-load/