...ormat. I want to create a new table based on this "data_as_xxx", which will contain 3 rows, and for each row, 3 fields T1, T2, T3, using the "LOAD from_field" instruction I have no problem with the c...
...oad. I have used the Subfield -> textbetween -> Generic Load -> left join I know there is also load from_field functionality where you can use xml simple but i am not sure how to parse this p...
...ubAttributes 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 [Q...
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...
...rompt/filePrompt/promptData/prompt/name] as [promptData/prompt/name],
RowNo() as %Key_ivrScript_6360329EA3A83B72 // Key to parent table: ivrScript
From_Field (Scripts_Main,IVRDetailsXml)(Xml...