Convert Column to Rows

[balanandam]

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

[rubenmarin]

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]

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