Help with unique records

[qlikuser222]

Hi All,

Can anyone please help me to achieve below results using Qlik

ID,  Name,  Date,       Country,   Type,   record

1,  Peter,    2/1/2019, USA,         EDIT,     123

1,  Peter,    2/1/2019, USA,        COPY,     567

I want the above records to be displayed as below in QLIK Table

ID,  Name,  Date,       Country,   Type,          record

1,  Peter,    2/1/2019, USA,         EDIT;COPY, 123;567

Thanks

[edwin · Accepted solution]

the nearest is a straight table:

add following dimensions: ID,  Name,  Date,  Country
add two expressions:
=concat(distinct type,';')
=concat(distinct record,';')

however, the problem with concat is it arranges the values in sort order so it will be 
COPY;EDIT    123;567

if a tweak is acceptable, use only one expression column:
=concat(distinct type & ';' & record, ',')
the advantage of this is that the type and corresponding record are paired up.

[Vegar]

You could probably get the order correct if you use the same sort-weight parameter in both the concat function. 

[edwin]

Thanks Vegar, i learned something today