topic Re: html tags embedded in xml data load. in QlikView

html tags embedded in xml data load.

nickedw0 — Mon, 05 Aug 2019 17:58:25 GMT

When I load a list from SharePoint using iwssvr.dll I get httml tags embedded in the data. An example is:

The load statement looks like this

Load ows_ID AS ID,

ows_Exception_x0020_ID as [Exception]

FROM [https://sp.....(xmlSimple, utf8,Table is [xml]);

Is there a way for Qlikview to ignore the html?

nickedw0 — Mon, 05 Aug 2019 18:02:10 GMT

should have said owssvr.dll

Brett_Bleess — Mon, 26 Aug 2019 12:13:24 GMT

The only thing that comes to mind is the Transform option in the data load wizard....

Hopefully this may do the trick.

Regards,
Brett