Show all the values in a column of a dimention in one cell

[SjoerdvdLaar]

I've got the following two names:

Names: Jack and Paul

Jack has performed the following actions:

Action, date

01, 12-12-2018

02, 13-12-2018

10, 30-12-2018

13, 28-12-2018

Paul has performed the following actions: 

Action, date

01, 15-12-2018

02, 17-12-2018

04, 19-12-2018

05, 21-12-2018

10, 25-12-2018

Now I want the following result:

Jack: 01, 02, 13, 10

Paul:  01, 02, 04, 05, 10

How can I do this?

[zhadrakas · Accepted solution]

try the following Expression with Dimension Names
concat(distinct Action, ',')

regards
tim

[shiveshsingh]

Your Script:

T:LOAD *,'Jack' as Key INLINE [

Action, date

01, 12-12-2018

02, 13-12-2018

10, 30-12-2018

13, 28-12-2018
];
T:LOAD *,'Paul' as Key INLINE [
Action,date
01, 15-12-2018

02, 17-12-2018

04, 19-12-2018

05, 21-12-2018

10, 25-12-2018];

Text box expression :

='Paul:' & Concat({<Key = {'Paul'}>}Action,',')

='Jack:' & Concat({<Key = {'Jack'}>}Action,',')

[SjoerdvdLaar]

Perfect, thanks!!