Merge Datasets

Options
HSMorales
HSMorales
edited February 11, 2022 in Analytics #1
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

Comments

  • ANNKRUSE
    ANNKRUSE
    edited December 31, 1969 #2
    Options
    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
    Hans_vd
    edited December 31, 1969 #3
    Options
    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
    Warning No formatter is installed for the format ipb
  • kosta
    kosta
    edited December 31, 1969 #4
    Options
    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 ipb
  • Hans_vd
    Hans_vd
    edited December 31, 1969 #5
    Options
    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
    Warning No formatter is installed for the format ipb

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs