Parsing JSON into a list from SQL

[TomerShal]

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!