Let us clear some constraints:
- XML is a snippet, but we can assume, that is defining XML Namespaces
More on this and how to handle here:
Some parts within the data are maybe a copy paste error or do have other defects (&
instead of &
)
After other cross-checking some alternate conversion tricks we would recommend:
- collect all distinct child element names from the Report_Entry element - myElementNames
- use myElementNames to construct dynamically an all over Datacolumn structure on an empty datatable
- iterate over all Report_Entry elements
- extract all current elements and values and use it for datatable population