Merge rows by order

[Mizo]

Hello,

I have a table that contains more data "Value".  However, the data belongs to one ID

I would like to merge the data and display it according to the order

my Table:

ID	RecordNumber	Value
ID_1	2	xxx
ID_1	1	yyy
ID_1	3	zzz
ID_2	1	AAA
ID_2	2	BBB
ID_3	3	CCC
ID_3	2	DDD
ID_3	4	EEE
ID_3	1	FFF
ID_4	1	GGG

The Result should by like:

ID	Value
ID_1	YYY XXX ZZZ
ID_2	AAA BBB
ID_3	FFF DDD CCC EEE
ID_4	GGG

Can someone please help me for this?

Best regards,

Mizo

[AshutoshBhumkar]

Hi, I dont think merging of cells is possible in Straight table in Qlik sense.

You can use Pivot table instead.

[Mizo]

Thanks for your replay

it works with following code:

Aggr(Concat(DISTINCT Value, ', '),ID)

But I don't know how to sort them by RecordNumber so that the data is displayed in the correct order

[PrashantSangle]

Try below

Aggr(Concat(DISTINCT Value, chr(10)),ID)

Regards,

Prashant Sangle

[AshutoshBhumkar]

Yes, Merging is not possible but you can concat the values of dimension

[AshutoshBhumkar · Accepted solution]

Hi, to Sort the dimensions after concat use below expression.

Aggr(Concat(DISTINCT Value, chr(10),RecordNumber),ID)

[Mizo]

Dear AshutoshBhumkar,

Thanks a lot for your help. It works 🙂