Hi all,
I want to use
LOAD ... From_Field (...)
to extract data from a field containing XML structured data. Let's say this is not an issue and I managed to successfully code that (a...
...ainSectionClosedTime], 'YYYY-MM-DD HH:MM:SS') As END ,FileTime( '$(vPathToXmlFile)' ) As FILE_TIME ,FileSize( '$(vPathToXmlFile)' ) As FILE_SIZE From_Field(R...
...onfiguration/some-xml-field] as SomeXmlFieldValue from_field (ConfigurationData,ConfigurationField) (XmlSimple, Table is [Configurations]); Drop Table ConfigurationData; Store ConfigurationXMLinto 'l...
Hello together,
i have a txt file which has a structure like a xml file.
Please see attached file.
How can i load the information with the posibility to define different t...
Hello I'm reading a table from SQL database the table has a column of type xml how can I parse this column in script? or is there another approach? kindly advise
Hi I am loading data from a SQL table, and one of the columns is an XML link that opens up to XML . I was wondering how I can parse the data from the XML column so that it becomes extra columns. F...
...t within QlikSense Have tried loading the XML into a separate XML file; RatingData: Load * FROM [Policy.QVD] (qvd); Store RatingData INTO RatingData.XML ; But as you can see from b...
