Discussion board where members can get started with QlikView.
I have one requirement as below. I have sample data like
I need this to be converted as
Hi, this can be done with Concat(), inscript needs a Group By clause:
Concat(contentype, ',') as contentype
Group by IMEI;
Edit: and maybe Concat(distinct contentype, ',') if you want to avoid repeated values.
Check this article on a generic load (reverse crosstable) https://qlikies.wordpress.com/2016/02/22/the-generic-load/