How to apply join by grouping the join conditions in Bold BI?

In Bold BI, when you need to perform group joins based on specific conditions, you can utilize the options available in the join window. Specifically, the ANDGROUP and ORGROUP options allow you to define the conditions under which the join should occur.

Steps to Apply Group Joins

1. Open the Join Window: Navigate to the data source where you want to apply the group join and open join window.

2. Select Join Type: Choose the appropriate join type based on your requirements (e.g., inner join).

3. Define Join Conditions:

   • Use ANDGROUP to specify that all conditions must be met for the join to occur. For example, you can join table B on multiple conditions such as:

(id = id AND place = place ) AND column = column. 

The brackets will be formed for ANDGROUP and any other condition can be added further.

• Use ORGROUP to specify that at least one of the conditions must be met. For example:

(id = id OR place = place ) AND column = column. 

The brackets will be formed for ORGROUP and any other condition can be added further.

4. Finalize the Join: After setting the conditions, finalize the join configuration and apply it to your data model.

By using these options, you can effectively manage complex join conditions in your Bold BI reports and dashboards.

Additional References

• Joining Tables in Bold BI