Use Merge Query to combine measures from multiple queries into a single query.
Merge Query simplifies reporting by combining related measures while preserving the existing row and column dimensions.
[!IMPORTANT] Merge Query works only when all selected queries use the same row and column dimensions. The queries can contain different measures.
Merge Query creates a new query. It doesn't modify the original queries.
The following example uses two product-based queries.
Both queries use the same ProductName and Category dimensions but contain different measures.
The Product Sales query contains sales measures.
| ProductName | Category | Units | Sales Amount |
|---|---|---|---|
| Camera M300 | Cameras and camcorders | 415 | 78.28K |
| Camera M200 | Cameras and camcorders | 362 | 68.06K |
| Camera X300 | Cameras and camcorders | 381 | 71.25K |
The Product Pricing query contains pricing measures.
| ProductName | Category | Unit Price | Unit Cost |
|---|---|---|---|
| Camera M300 | Cameras and camcorders | 27.52K | 12.66K |
| Camera M200 | Cameras and camcorders | 22.56K | 10.37K |
| Camera X300 | Cameras and camcorders | 23.18K | 10.66K |
After you merge the queries, the new query contains the shared dimensions with measures from both queries.
| ProductName | Category | Units | Sales Amount | Unit Price | Unit Cost |
|---|---|---|---|---|---|
| Camera M300 | Cameras and camcorders | 415 | 78.28K | 27.52K | 12.66K |
| Camera M200 | Cameras and camcorders | 362 | 68.06K | 22.56K | 10.37K |
| Camera X300 | Cameras and camcorders | 381 | 71.25K | 23.18K | 10.66K |
This example merges the Product Sales query and Product Pricing query.
The Product Sales query contains the shared dimensions ProductName and Category, together with the Units and Sales Amount measures.
The Product Pricing query uses the same dimensions and contains the Unit Price and Unit Cost measures.
To merge queries:
On the Home ribbon, select Merge Query.
In the Merge Query dialog, add the queries that you want to merge.
For the Product Sales query, select the measures to include in the merged query.
In this example, select:
For the Product Pricing query, select the measures to include in the merged query.
In this example, select:
Select Apply.
Infobridge creates a new merged query.
The merged query preserves the shared row and column dimensions and combines the measures from all selected queries.
