Different values in one row

[#1]

Hi!

I have many clientIDs linked to every sales manager.

I created the simple table below:

sales manager	email	clientID
David	d@d.com	1
David	d@d.com	2
David	d@d.com	3
David	d@d.com	4
Saul	s@s.com	5
Saul	s@s.com	6

I would like to create this table, and put all the clientIDs in the same row, for every sales manager:

sales manager	email	clientID
David	d@d.com	1,2,3,4
Saul	s@s.com	5,6

thanks ,

Naama

[sunny_talwar]

Try this:

Table:

LOAD [sales manager],

          Only(email) as email,

          Concat(clientID, ', ') as clientID

From Source

Group By [sales manager];

[sunny_talwar]

For your sample:

Table:

LOAD [sales manager],

          Only(email) as email,

          Concat(clientID, ',') as clientID

Group By [sales manager];

LOAD [sales manager],

    email,

    clientID

FROM

[https://community.qlik.com/thread/193637]

(html, codepage is 1252, embedded labels, table is @1);

[anlonghi2]

Hello Naamamor,

use Sales manager and email as dimensions of a straight table and define the expression as concat(clientID,',')

Look at attached qvw

Best regards

Andrea