Home
Analytics
Merge Datasets
HSMorales
I have 3 datasets that are created using 3 stored procedures. The 3 data sets have 1 common field. How can I create a forth data set that combines all 3 datasets??
Example:
The first dataset has fields Insurance_Name, Coverage_Opt, Coverage_Type
The Second data set has fields Insurance_Name, Insured Name
The Third data set has fields Insurance_Name, Level
In my detail I would like to list:
Line 1: Insurance_Name Coverage_Opt Coverage_Type
Line 2: Insured_Name Level
Insurance_Name may or may not exist in the second and third datasets.
Is there an easy way to do this ??
I am running BIRT version 3.7.0
Thanks
Find more posts tagged with
Comments
ANNKRUSE
Create a select statement to access all three data sets based on Insurance_name.<br />
<br />
<blockquote class='ipsBlockquote' data-author="'HSMorales'" data-cid="99535" data-time="1335188806" data-date="23 April 2012 - 06:46 AM"><p>
I have 3 datasets that are created using 3 stored procedures. The 3 data sets have 1 common field. How can I create a forth data set that combines all 3 datasets?? <br />
<br />
Example:<br />
<br />
The first dataset has fields Insurance_Name, Coverage_Opt, Coverage_Type<br />
<br />
The Second data set has fields Insurance_Name, Insured Name <br />
<br />
The Third data set has fields Insurance_Name, Level<br />
<br />
In my detail I would like to list:<br />
<br />
Line 1: Insurance_Name Coverage_Opt Coverage_Type<br />
Line 2: Insured_Name Level<br />
<br />
<br />
Insurance_Name may or may not exist in the second and third datasets. <br />
<br />
Is there an easy way to do this ??<br />
<br />
<br />
I am running BIRT version 3.7.0 <br />
<br />
Thanks<br /></p></blockquote>
Hans_vd
You can also create a joint dataset on the first and the second dataset
Then create a joint dataset on the joint dataset you created and the third dataset
In both joint datasets use LEFT OUTER JOIN as the join type
Regards
Hans
kosta
Hello everyone,
check this one for merging data sets:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1215-create-union-data-set/
Cheers.
Hans_vd
Hi Kosta,
Not sure why you post that link in this almost-a-year-old post. Nobody was looking for a union in this thread.
Regards
Hans
