Data Builder - Join
- Mahisha Chandrakumar CTOO (Unlicensed)
Sigma enables you to create reports by combining different datasources using several join operations in Studio. For instance, the following screenshot shows a report, Account Details Report created combining Transaction and Address datasources using join operation:
Perform the following steps in Sigma Studio to combine datasources using JOIN option:
- Click Data Builder.
The Data Builder menu option appears only when the CONNECTIONS on the left navigation is selected.
A page appears where the new data source aggregator can be created easily through drag-and-drop.
- Click edit (
) icon to edit the data source aggregator's name. Here, ACCOUNT DETAILS is used as the name for data source aggregator.
- Select Parent Data source from Data Source ID drop-down list, which appears on the right-hand side of the page. For example, TRANSACTION is chosen as the data source.
- Drag and drop another data from the left-hand side of the page 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 list. For example, ADDRESS is chosen as the data source.
The Data Source ID selected can either be a database or a web service data source made for the report.
- Click Join.
- Select a Join option. Here, Left Join is selected.
- If you click Left Join, all entries on the left datasource and matching records from the right datasouce will be displayed based on the provided key column. For example, consider the report shown on the following screenshot. Here, Account Number 5500000852 is the additional entry on TRANSACTION datasource. However all entries from the TRANSACTION (left) datasource and matching records from the ADDRESS (right) datasource are displayed based on the provided key column (Account Number).
- If you click Equi Join, only the similar entries on datasources will be displayed based on the parent and the child column selected. For example, consider the report shown on the following screenshot. Here, Account Number 5500000852, the additional entry on TRANSACTION datasource will be eliminated and only the matching data from the two datasources will be displayed based on the provided key column (Account Number).
- If you click Right Join, all entries on the right datasource and matching records from the left datasouce will be displayed based on the provided key column.For example, consider the report shown on the following screenshot. Here, Account Number 5500000852 is the additional entry on TRANSACTION datasource. Thus the additional entry on TRANSACTION (left) datasource will be eliminated and all records from the ADDRESS (right) datasource are displayed based on the provided key column (Account Number).
- Select Parent Column and Child Column from the drop-down list. For example, ACCOUNT_NO is chosen as the parent and the child column in this data builder.
- Click save (
) icon to save the data aggregator. 
A confirmation message appears.
- Click OK for the message.
- Now, proceed with the configuration and generation of the report. Refer Configuring a Complex Report and Generating Complex Report in Sigma for more information on configuring and generating the report.
Copyright © Intellect Design Arena Limited.
All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.