Merge queries

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.

Example scenario

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

Merge queries

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:

1. On the Home ribbon, select Merge Query.

2. In the Merge Query dialog, add the queries that you want to merge.

3. For the Product Sales query, select the measures to include in the merged query.

   In this example, select:

   • Sum of Units

   • Sum of Sales Amount

   
4. For the Product Pricing query, select the measures to include in the merged query.

   In this example, select:

   • Sum of Unit Price

   • Sum of Unit Cost

   
5. Select Apply.

   

6. Infobridge creates a new merged query.

   The merged query preserves the shared row and column dimensions and combines the measures from all selected queries.