Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

xml data handling with from_field

Hi

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

Tags (3)
1 Reply
Not applicable

xml data handling with from_field

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

Community Browser