Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

from_field for extracting xml-values

Hi

I access a ssrs reporting server to retrieve information on published reports.

The query returns an XML with the embedded report information.

I can capture the report definition with

Reports:

SELECT Name, CAST(CAST(Content AS VARBINARY(MAX)) AS XML) AS ReportXML

from <my_SQL_table>;

I currently use a macro to dump the XML-Data back into report files and used the Table Files Wizard to get the XML values.

LOAD xmlns:rd,

    xmlns,

    Width

FROM <my_dump_file> (XmlSimple, Table is [Report]);

I then read about the "from_field" command and thought I could circumvent the macro step and simply read from the above "ReportXML" field.

LOAD xmlns:rd,

    xmlns,

    Width

FROM_FIELD (Reports, ReportXML) (XmlSimple, Table is [Report]);

This however gives me an "Unknown Error in MSXML".

An example I found used @1 to refer to the FROM_FIELD content but I can't figure out how to script that.

Thanks

0 Replies