Distinct Data Set with xml source?

PhilippArndt · 2008-05-20T01:00:13+00:00

Hello, I need to have a distinct table for the following xml data source: <pre class='_prettyXprint _lang-auto _linenums:0'> <?xml version="1.0" encoding="iso-8859-1"?> <A> <D>1</D> <E>1234</E> </A> <A> <D>2</D> <E>4321</E> …

PhilippArndt

Hello, 
I need to have a distinct table for the following xml data source: 
 
<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>
 
 
The Result should be a table like this: 
<pre class='_prettyXprint _lang-auto _linenums:0'>

| 1 | 1234 |
| 2 | 4321 |

</pre>
How can I do this with BIRT?

Find more posts tagged with

Comments

averma

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.

Ashwini

PhilippArndt

thanks, the root node is really missing in my sample. But this is not the problem. Your sample returns a table: 
<pre class='_prettyXprint _lang-auto _linenums:0'>

| 1 | 1234 |
| 2 | 4321 |
| 2 | 4321 |
| 1 | 1234 |

</pre>
 
But it should only contain two elements (for example D as unique key). 
The result should be: 
<pre class='_prettyXprint _lang-auto _linenums:0'>

| 1 | 1234 |
| 2 | 4321 |

</pre>
 
<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>

averma

Hi PhilippArndt:
For this I would recommend using scripted data source.

Ashwini