Merging Data
The Merge Queries tool in Power Query allows you to join two tables based on a shared column, combining related data from each table into a single dataset.
- Most data software have some ability to join data sets together through the use of merge tools
- ability to pick up and merge data sets together via a common field or fields allows us to tie critical information together in record format
- Queries are a form of merging data
- include the tables and the join type
- merge tool will allow you to select the tables and establish the join types