XML Content Extraction from a table without having physical xml files

[Anonymous]

Hi All,

     I have a table that contains the xml headers along with the content in each cell of the table, but I don't have any external xml files. I have to extract data based on the information from those cells dynamically. Any hint how to do it?

Here is a sample of the data of a single cell in the table

<?xml version="1.0"?>

<root available-locales="de_DE" default-locale="de_DE">

  <dynamic-element instance-id="2H4YBTMn" name="Project_Health" type="list" index-type="">

  <dynamic-content><![CDATA[none]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="2Vct5d8N" name="Project_Status" type="list" index-type="">

  <dynamic-content><![CDATA[IOP]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="nJ5vMR9x" name="Project_Status_Brief" type="text" index-type="">

  <dynamic-content><![CDATA[Current contract will run out in 2015, Offers from different vendores being requested ]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="TMSs8BWX" name="Roadblock_Brief" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="0GrmC6Mj" name="Key_Issues" type="text_area" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="HdqfC2tq" name="Project_Start" type="date" index-type="">

  <dynamic-content><![CDATA[1/01/2015]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="sYcE3IMT" name="Project_Finish" type="date" index-type="">

  <dynamic-content><![CDATA[12/31/2015]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="HPZUqd9U" name="Project_Description" type="text_area" index-type="">

  <dynamic-content><![CDATA[<p>

  Current contract with Konica Minolta runs out in 2015. Currently no wish to move away from this solution. New contract needs to get set up - maybe switch to financial lease?</p>

]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="cV80n7H1" name="Financials" type="selection_break" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="zFgB3tBi" name="CEAR_ID" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="g8Pve8Wm" name="Lights" type="boolean" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="aDDx7EjC" name="Priority" type="list" index-type="">

  <dynamic-content><![CDATA[1]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="SdCT3xV5" name="Funding_Status" type="list" index-type="">

  <dynamic-content><![CDATA[Unknown]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="3AhO9z6M" name="Currency" type="list" index-type="">

  <dynamic-content><![CDATA[None]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="kNRP6quu" name="CAPEX" type="selection_break" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="TijePK7p" name="Current_Cost_CapEx" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="rzSKi7n0" name="Original_Cost_CapEx" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="Tr1no4US" name="OPEX" type="selection_break" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="vpqLr81i" name="Current_Cost_OpEx" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="GuWOZ5tk" name="Original_Cost_OpEx" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="uiOE1Gmq" name="OPEX_Recurring" type="selection_break" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="2lakUYTu" name="Current_Cost_OpEx_Recurring" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="wxJ3Z8vV" name="Original_Cost_OpEx_Recurring" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="GllLGaB5" name="Financial_Explanations" type="text_area" index-type="">

  <dynamic-content><![CDATA[<p>

  No financial details yet.</p>

]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="N18Am9Xz" name="Ownership" type="selection_break" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="4wDsDNhV" name="Business_Owner" type="text" index-type="">

  <dynamic-content><![CDATA[Frankie Vangeel]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="NO7derpB" name="Business_Project_Lead" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="jcV3hesW" name="IS_Project_Lead" type="text" index-type="">

  <dynamic-content><![CDATA[Heiko Decker]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="mlB0hLpS" name="Steering_Committee_Members" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="XyHnnMj4" name="Project_Team_Members" type="text_area" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="HsJd8h39" name="Region" type="list" index-type="">

  <dynamic-content><![CDATA[EU]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="ZCQ7djEH" name="Business_Area" type="text" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="mP8qGtIu" name="CIO_Project" type="boolean" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="shGlqD3d" name="IS_VP" type="list" index-type="">

  <dynamic-content><![CDATA[John Bloszinsky]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="Awi7GgqZ" name="IS_Director" type="list" index-type="">

  <dynamic-content><![CDATA[Axel Hagedorn]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="RoWsWm3I" name="IS_Area" type="multi-list" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="dQuuhA79" name="IS_System" type="multi-list" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="3hIHCDCV" name="Project_Software_Purchase_Expected" type="boolean" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="mSxynk8G" name="IO_Team" type="multi-list" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="Wq3oBuOn" name="Milestones" type="text_area" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="Py1JwQfO" name="Goals_Objectives" type="text_area" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="P47oTfHU" name="Dependencies" type="text_area" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="c3ERpuvr" name="Project_Risk" type="text_area" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="flkeIAX2" name="Technology_Changes" type="text_area" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

  <dynamic-element instance-id="Znp3CMC8" name="VWR_Liferay_System_Project_Report" type="selection_break" index-type="">

  <dynamic-content><![CDATA[]]></dynamic-content>

  </dynamic-element>

</root>

[marcus_sommer]

Within the table-wizard is an option available to load a file as xml-file and are there no invalid data-structures within the xml you won't be have much efforts.

- Marcus

[Anonymous]

We do not have xml files physically, instead we are just loading the xml content into the tables of qlikview.

[marcus_sommer]

I think then this would be helpful: https://www.qlik2go.net/en/2014/08/08/b/

- Marcus