topic Question about concat stuff in QlikView

Question about concat stuff

marcel_olmo — Wed, 12 Sep 2012 14:49:58 GMT

Hi guys, I'm wondering how to do the following thing :

I have a table like this :

And I would like to concat the values in rows by three as the following :

concats_users
U1,U2,U3
U4,U5,U6

How could you do that??

Many thanks in advance.

Cheers!

hic — Wed, 12 Sep 2012 16:25:23 GMT

Not sure what rule you want to use for the grouping, but this could be a solution:

Load

Concat(distinct user_id,',') as concats_user_ids,

Concat(distinct user,',') as concats_users,

Group

group by Group;

Load user_id, user, div(user_id-1,3) as Group

inline

[user_id,user

1,U1

2,U2

3,U3

4,U4

5,U5

6,U6];

HIC