Merge Datasets
Options
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
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
0
Comments
-
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>0 -
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
HansWarning No formatter is installed for the format ipb0 -
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.Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax