Forum Discussion
ITTom365
Oct 06, 2022Brass Contributor
Power Query append query 2 results to query 1 results
Hello, I hope someone might be able to help me with something I assumed would be simple. Background: I currently use VBA to connect to two different network shares, from which I grab lots...
- Oct 06, 2022
ITTom365 Make sure you have both "connection only" queries in one Excel file. Then, on the Home tab in the PQ editor, select Append Queries as New and follow the instructions in the next screen.
Now you'll have one larger table where you can perform your clean-up transformations.
Riny_van_Eekelen
Oct 06, 2022Platinum Contributor
ITTom365 Make sure you have both "connection only" queries in one Excel file. Then, on the Home tab in the PQ editor, select Append Queries as New and follow the instructions in the next screen.
Now you'll have one larger table where you can perform your clean-up transformations.
ITTom365
Oct 06, 2022Brass Contributor
That really was very simple - thanks