Page Comparison

...

Perform the following steps in Sigma Studio to combine data sources using EQUI JOIN option:

1. Click Data Builder.
   

   Image RemovedImage Added

   
   The Data Builder menu option appears only when the CONNECTIONS on the left navigation is selected.
   The Data Builder screen appears.
   

   Image Removed

   
   

   Image Added

2. 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.
   

   Image RemovedImage Added

   
   

3. 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.
   

   Image RemovedImage Added

4. Drag and drop another data from the left-hand side and connect the parent data source with this data.
   

   

5. 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.
   

   Image RemovedImage Added

6. Click Join.
   

   Image RemovedImage Added

7. 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.
   

   Image RemovedImage Added

   
   

8. In the Join On Keys section, select the Parent and Child columns from the respective Parent Column and Child Column lookup fields.
   

   Image RemovedImage Added

9. Click the Save to save the data source aggregator.
   

   Image RemovedImage Added

   
   A confirmation message appears.
   

   Image RemovedImage Added

10. Click Ok.

Now, proceed with the report configuration.


On using the Left Join option in a data source aggregator, all entries on the left data source and matching records from the right data source are displayed based on the key column. For example, consider the report shown on the following screenshot. Here, BENE_ ACC_NO 10001000233 & 10001000232 is the additional entry on 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 displayed based on the key column (BENE_ACC_NO).

...