Merge 3 connections into 1

[Craigc3814]

I have three connection queries. One is called Work Orders, One is called Time Keeping, and the other is All EE.

Currently I am merging Work Orders, and Time Keeping on Work Order # and creating a new query, then merging All EE with that new query on Employee ID.

IS there a way to Merge all three at once. So have All EE and Time Keeping merge on Employee number, then once those are merged, merge again with Work Orders based on Work order number?


It contains quite a bit a data and the sheet is running slow, trying to clean it up.

 

[Matt Allington]

i think merge (as opposed to append) is one at a time. I Doubt it would speed thing so up anyway. How long does it take? You could try turning off background preview refresh in the options.

 

[tallan]

Not sure if your 3 connection queries are coming from the same or different sources. If they are coming from a relational database like SQL Server, consider merging (joining) them with a data view before importing.

Tom
PowerPivotPro - Transforming your Business with Power Pivot and Power BI