Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
id | name | user_id | labels |
---|---|---|---|
"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
I've done using the loading with Resident keyword ,,
so Thanks alot ,, I'll mark this an answer
Thanks again