Distinct Data Set with xml source?
PhilippArndt
Member
Hello,<br />
I need to have a distinct table for the following xml data source:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0" encoding="iso-8859-1"?>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
</pre>
<br />
<br />
The Result should be a table like this:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
| 1 | 1234 |
| 2 | 4321 |
</pre>
How can I do this with BIRT?
I need to have a distinct table for the following xml data source:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0" encoding="iso-8859-1"?>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
</pre>
<br />
<br />
The Result should be a table like this:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
| 1 | 1234 |
| 2 | 4321 |
</pre>
How can I do this with BIRT?
0
Comments
-
Hi PhilippArndt:
You XML file is malformed, you are missing the root element. I have modified the data to fix the issue and I am attaching a sample report that uses this file. The report design expects the file in C:temp.
Hope this helps.
AshwiniWarning No formatter is installed for the format ipb0 -
thanks, the root node is really missing in my sample. But this is not the problem. Your sample returns a table:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
| 1 | 1234 |
| 2 | 4321 |
| 2 | 4321 |
| 1 | 1234 |
</pre>
<br />
But it should only contain two elements (for example D as unique key).<br />
The result should be:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
| 1 | 1234 |
| 2 | 4321 |
</pre>
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0" encoding="iso-8859-1"?>
<F>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
</F>
</pre>0
Categories
- All Categories
- 117 Developer Announcements
- 52 Articles
- 145 General Questions
- 133 Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 912 Cloud Fax and Notifications
- 81 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 167 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 4 XM Fax