Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
marcel_olmo
Partner Ambassador
Partner Ambassador

Question about concat stuff

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

I have a table like this :

user_iduser
1U1
2U2
3U3
4U4
5U5
6U6

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!

1 Reply
hic
Former Employee
Former Employee

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