Loading an XML field in SQL Server into Qlik Sense
I have a SQL server field that displays entire XML scripts in each row as a link. So in SQL server if you click on that link it expands the xml script into a seperate tab so it is easy to read the script. I was able to load the field into Qlik Sense. I was wondering if there is a way to make the xml more presentable into separate lines.
Re: Loading an XML field in SQL Server into Qlik Sense
Thanks Petter for the quick response. The thing with the XML field is, each row in the field are different sql xml files. So it becomes cumbersome to manually read the contents in each xml and create fields in qlik sense for each of these XML files. So, I was thinking if I can even open the xml link on a seperate tab or a window, something that simply expands the script would be fine.
Sorry, I can't add screenshots to explain better. Its private data.