xml data handling with from_field

Thu, 17 Nov 2011 16:00:39 GMT

The table I have to query has an XML-structure in one of the Attributes.

I can get the XML-Content using

Table1:

SELECT ID, Type, CAST(CAST(Content as VARBINARY(MAX)) as XML) as SubAttributes

How can I have the "Content" be further parsed to get the XML-information into a QV-Table? Read about the FROM_FIELD instruction but can not figure out proper syntax.

Inside_Data:

LOAD [Query/CommandText] as CommandText

?? FROM_FIELD SubAttributes -- does not work

Unfortunately did not get an answer to a similar question asked a few weeks ago.

Thanks, Juerg

xml data handling with from_field

Mon, 26 Mar 2012 13:55:10 GMT

I had a similar issue and had to use textbetween to get the info we wanted.

LOAD

TextBetween(Textbetween(SubAttributes, '<Query>','</Query>'),'<CommandText>','</CommandText>')

Mark

topic xml data handling with from_field in QlikView

xml data handling with from_field

xml data handling with from_field