How to Append Data Sources Using Extracted Views in Bold BI

Combining data sources using extracted views in Bold BI can be achieved by following these steps:

Step 1: Connect to Database and Extract View1

Connect to your database and extract the first view (View 1) that you want to append.

Step 2: Switch to Code View Mode in Bold BI

Switch to the code view mode in Bold BI to see the SQL code for the extracted view.

Step 3: Connect to Database and Extract View2

Connect to your database again and extract the second view (View 2) that you want to append. Switch to code view mode to see the SQL code for this view.

Step 4: Copy the Code from View2

Copy the SQL code displayed in the code view mode of the data source created using View 2.

Step 5: Append the Code of View1 and View2

Open the code view of View 1 and append the code of View 2 using the UNION operation as shown below:

SELECT * FROM View1
UNION
SELECT * FROM View2

Step 6: Run the appended code

Click on the “Run” button to execute the appended SQL code.

Step 7: Update the Data Source

Click on the “Update” button to see the result of the appended data sources.