Forums

Full Version: Appending tables and merging them using Designer
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Does Appending the two tables and merging the tables cannot be done in the BDB?
(05-22-2019, 10:24 AM)noopur.mehrotra Wrote: [ -> ]Does Appending the two tables and merging the tables cannot be done in the BDB?

Append can be achived using query in datasets. Click on the connection icon in the dashboard and click on the datasets you want to merge. Select all the field needed. Click on the plus icon in criteria and select the join condition.
Appending & Merging of Tables can be achieved in BDB through below ways.

1 - We can write SQL query with Union/Join to append/Merge the tables and create the Data Set which can be consumed in BDB Dashboard Designer.
2 - We can merge Data sets in the Dashboard Designer using a unique common id between the datasets.
  • Click on the connection icon in the dashboard and select merge connection option. 
  • Select on the datasets you want to merge. 
  • Select the fields needed from both data sets.
  • Click on the plus icon in criteria and select the join condition.