Set fusion

Hi,

I wanted to know if there is a way to make a fusion with 2 sets.

For example I've 2 databases with the same table in each with 2 fields :
DateTime - Value

Is there any way to make a set of which is the concatenation of the 2 previous sets in order to make a chart in my report ?

Regards - Matthieu

Find more posts tagged with

Comments

mwilliams

Hi Matthieu,

A joint dataSet should be able to do this.

Matthieu

I already tried but it doesn't work.
What i would like to do is to keep the same number of fields.

For example :

Set 1:
ID --- Value
1 --> FirstValue
2 --> SecondValue

Set 2:
ID --- Value
3 --> ThirdValue
4 --> FourthValue

The result I'm expecting is:

Final Set:
ID --- Value
1 --> FirstValue
2 --> SecondValue
3 --> ThirdValue
4 --> FourthValue

CBR

Hi,

when creating a Joint Data Set you should be able to choose from
"Left Join"
"Right Join"
"Inner Join"
and
"Union"

The option Union exists since Birt 2.5 and is the option you have to choose to join your data sets in that way you want them to join.
So if you re using Birt 2.3.2 or earlier version a Joint Data Set isn't a solution for you. For earlier versions you can use Birts Event Scripting on the datasets to achieve the same thing.

Matthieu

Thanks a lot for the informations.

I'm using BIRT 2.3.2 for some compliance reasons. Let's see with the 2.5

Thanks again.

mwilliams

Matthieu,

With BIRT 2.3.2 and before, you could still use a joint dataset with a full outer join and use computed columns to join them into a single column with a simple if statement.

If you need more explanation, let me know. Hope this helps.