Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

multi valued field representation

I want to represent a multi valued field in qlik sense

let's say I have the following structure of data

{

     "id":"648435107775119360",

     "name":"Ali",

     "user_id" : "39224569"

     "labels" : [1,2,3]

}

and I have a lookup for labels as an inline table that will be used for mapping

I want to map the object above to be something like

idnameuser_idlabels
"648435107775119360""Ali""39224569""Complaint,Question,Sales"

so that I can use the labels field as a dimension,

can I make a multi valued field in the table ,, or should I create something like an associative table between the main table and the labels table ?

It would be nice if you could provide a load script sample ??

thanks

10 Replies
Not applicable
Author

I've done using the loading with Resident keyword ,,

so Thanks alot ,, I'll mark this an answer

Thanks again