Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Nikhil2725
Creator II
Creator II

Comma separated values

Hi All,

I have table below:

user_idSubject_access_tracking_idsubject_idLender_offer_id
22725441154
215895611154
215895721154
215895831154
7708043
72002613
1214944
1215814
1216624
1216734
134015
134125
134235
134445

 

However, I want to display like below:

user_idLender_offer_idSelection_order
211544,1,2,3
734,1
1244,1,2,3
1351,2,3,4

 

Kindly help me in displaying.

 

 

12 Replies
Shubham_Deshmukh
Specialist
Specialist

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
Creator II
Creator II
Author

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

Great, Kudos !!