...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...
...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...
Hello, I'm reading XML data directly from an Oracle DB BLOB field which is working fine except that certain characters are not parsed properly. The word "Qualität" for example i...
I have a requirement, where i need to load a number of rows from a database table, where a column contains XML data. I tried using From_Field function, and saw few people having tried this in t...
We have XML stored in a CLOB on our database. We can query the DB and store the CLOB in a QVD with no issues. When we go to load the CLOB, I want to be able to parse/split the XML in to fields. S...
Hi All, I have field called Information in the database and in that field the XML Data are load, Now i want to separate the XML data in the field information. EX XML D...
