...
Click Data Builder.
The Data Builder menu option appears only when the CONNECTIONS on the left navigation is selected.
The Data Builder screen appears.
Enter the Name and ID of the data source aggregator in the Name and ID fields. Here, DATA_BUILDER_JOINS is used as the name and ID for data source aggregator.
Select Parent Data source from Data Source ID drop-down field, which appears on the right-hand side. For example, BENE_DS2 is chosen as the data source.
Drag and drop another data from the left-hand side and connect the parent data source with this data.
Click the data element and select data source ID from the Data Source ID drop-down field. For example, TRAN_SUMMARY_DS2 is chosen as the data source.
Click Join.
Select any one of the Join options. Here, Equi Join is selected.
NOTE:
An equijoin returns only the rows that have equivalent values for the specified columns in all the datasources. Here, BENE_ACC_NOis the specified column.
In the Join On Keys section, select the Parent and Child columns from the respective Parent Column and Child Column lookup fields.
Click the Save to save the data source aggregator.
A confirmation message appears.
Click Ok.
Now, proceed with the report configuration.
On using the Left Join the Equi Join option in a data source aggregator , all to configure a report, only the similar entries on the left data source and matching records from the right data source are data sources will be displayed based on the key columnselect parent and child columns. For example, consider the report shown on the following screenshot. Here, BENE_ ACC_NO 10001000233 & 10001000232 is , the additional entry on BENE Bene data source . However, all entries from the BENE DATA (left table) data source and matching records from the TRAN SUMMARY DATA (right table) data source are will be eliminated and only the matching data from the two data sources will be displayed based on the provided key column (BENE_ACC_NO).
...