Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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,',')