Joined data sets allow you to analyze data from more data sets together and therefore use data from more data sources in a single report.
To create join in BellaDati:
- Navigate to one of the Data Sets you want to use in join
- Click on Joined Data Sets in Settings section of the left action bar
- Choose Create Join
- Select Data Set to be joined with
Each join has to have specified following parameters:
- Name: Joined data set name.
- Join with: Name of the source data set to join with.
- Join type: Standard join types available - match always depends on attributes.
- Left outer join: Record in the target data set is not mandatory.
- Inner join: Record in the target data set is mandatory.
- Custom join: User can define own joining condition. If not specified, no attribute match is required (Cross join).
Custom Join Condition
BellaDati allows you to define you own joining condition. To do so:
- Select Custom in Join Condition
- Cross join will be automatically applied
- Type joining condition to restrict the output
Multiple Join Points
One data set could be joined with more data sets (eg. join by department ID to get department full name, address, country, total sales and then join by product ID to get products name, price, weight and mass). Each join is called join point.
To add another joining point into existing join:
- Click on add joining item
- Select desired Data Set
- Continue with Join Conditions
Joining Facts and Restrictions
Joined data set supports these functions the same way like in ordinary data set: