Join Two datasets

kalpana5

<p>Hi,</p><p> </p><p>Could anyone please let me know how to join two datasets and under what circumstances do we join two datasets.</p><p> </p><p>Thanks.</p>

GLO_FR

<p>Hi,

you can join 2 (or more) datasets in the "Data Explorer" or in the "Outline" windows of the BIRT designer.

Do a right click on the Data Sets icon and choose join Data Set.

Most of the time, you use this function when you have datasets from several data sources and you to obtain a final result using the relation between your datasets (like in SQL).

Compared to SQL, you can only make very simple "link" between your data, otherwise it is exactly the same as a "join" function in SQL</p>