...
Perform the following steps in Sigma Studio to combine data sources using EQUI JOIN option:
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 Equi Join option in a data source aggregator
...
to configure a report, only the similar entries on
...
data sources will be displayed based on the
...
select parent and child columns. For example, consider the report shown on the following screenshot. Here, BENE_ ACC_NO 10001000233
...
, the additional entry on
...
Bene data source
...
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).
...