Full Outer Join Between Different Data Sources in Bold BI

In Bold BI, you can use a Full Outer Join to combine two different tables from different data sources when you need all data from both the tables. This can be done using the code view mode on shared data sources.

Steps to Create a Full Outer Join

1. View the Shared Data Sources Tables List: Navigate to the shared data sources tables list.
   

   

2. Drag and Drop Any Table: Select any table from the list and drag and drop it into the workspace.

3. Switch to Code View Mode: After dropping the table, switch to code view mode.

4. Change the Inner Join to Full Outer Join: In the code view mode, change the ‘inner join’ to ‘full outer join’.

5. Execute the Query: After making the necessary changes, select ‘execute the query’.
   

   

By following these steps, you can create a full outer join between two different data sources in Bold BI. This allows you to use fields from different data sources in the same widget.

Related Articles

• Shared Table