detaching json string in DB into seperate records in qvds
in our MYSQL data base there is a column in Json format that represents all the possible reasons for a certain result in a catenated string.
i would like to be able to detach the format for every different reason in order to be able to show the user what were the reasons that caused each result.
is there a way to convert a Json string into a readable format in a qvd?
as far as I know, QlikView cannot read directly json format.
You could try to extract the field as string and then work with string manipulation to have your desired result, or look if this thread is useful: JSON connector
