Data retrieving of 'flat'/generic XML [message #1760205] |
Mon, 24 April 2017 14:21 |
Manuel Wasinger Messages: 1 Registered: April 2017 |
Junior Member |
|
|
Hi,
I'm quite new to BIRT but already managed to design some reports.
But now I am confronted with quite a generic XML structure and can't manage to receive the data in any usable way.
The XML looks like this...
<DataDetailsList>
<element>
<textNo>1000</textNo>
<param1>Mrs.</param1>
</element>
<element>
<textNo>1010</textNo>
<param1>Susan</param1>
<param2>Smith</param1>
</element>
<element>
<textNo>1020</textNo>
<param1>Addressline 1</param1>
</element>
<element>
<textNo>1030</textNo>
<param1>Addressline 2</param1>
</element>
</reportDataDetailsList>
There's only one structure with an attribute 'textNo' which contains the semantic info about the meaning of the following attributes.
In the example above textNo '1000' tells me that the value in <param1> is the salutation, '1010' delivers the name in two parameters etc.
(Each XML dataset contains information for a single customer letter.)
Ideally, I'd like to create a data set "Address" in which these <elements> are mapped to one single row with columns "Salutation", "First Name", "Second Name"...
I would've a solution if the textNo would be an attribute of <element>... I mean: <element textNo = 1000>
In this case, I could make a column mapping for "Salutation" with an XPath expression like /element[@textNo="1000"]/param1
But with the existing structure I can't find a solution.
Any ideas out there?
Kind regards,
Manuel
|
|
|
Powered by
FUDForum. Page generated in 0.03108 seconds