TomerShal
Contributor
2020-04-05
03:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Parsing JSON into a list from SQL
Hello guys,
I am trying to load a JSON field from SQL into Qliksense, and put into a list to match a column field. This is an example of what it looks like in SQL:
id JSON
1 ["name1","name2","name3"]
2 ["name4","name5","name6"]
3 ["name7","name8","name9"]
The end goal is using set analysis 'Match()' function to know if the id has on of the names. So I thought I need to parse each name, per id, into a list or a variable of some sort, but I can't make it happen. I am loading the data from SQL DB like so:
SQL
SELECT id, JSON FROM table;
Thank you in advance!
640 Views
0 Replies