Comma separated values

[Nikhil2725]

Hi All,

I have table below:

user_id	Subject_access_tracking_id	subject_id	Lender_offer_id
2	27254	4	1154
2	158956	1	1154
2	158957	2	1154
2	158958	3	1154
7	7080	4	3
7	20026	1	3
12	149	4	4
12	158	1	4
12	166	2	4
12	167	3	4
13	40	1	5
13	41	2	5
13	42	3	5
13	44	4	5

However, I want to display like below:

user_id	Lender_offer_id	Selection_order
2	1154	4,1,2,3
7	3	4,1
12	4	4,1,2,3
13	5	1,2,3,4

Kindly help me in displaying.

[Shubham_Deshmukh · Accepted solution]

Try this :

myData:
LOAD user_id, 
     Subject_access_tracking_id, 
     subject_id, 
     Lender_offer_id
     FROM
yourDbTable;

residentData:
Load *,RowNo()
Resident myData;

drop table myData;

Read about resident load - it plays imp role in Qlik data modelling.

[Nikhil2725]

Hi Shubham_Deshmukh,
Thanks a lot... It worked...:)

[Shubham_Deshmukh]

Great, Kudos !!