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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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