I'm trying to import movie credits data into Qlik Sense, however I'm struggling because the data is formatted in JSON. Can someone point me in the right direction on how to import this data?
Attached are the first few lines in the data file.
I have not found a way of importing a json data format text file, although one can import data in json format via REST API, but that will no use for importing your file.
p.s. Having had a quick look at the contents of your file it does not look like properly formatted json. It looks like a csv file that contains json snippets in each discrete csv segment.
