Forum Discussion
Combine power query output table with manually maintained column in one excel table
- Jan 22, 2021
Zdenek_Moravec Not too long ago, similar questions came up on this forum. Both were responded to by
Thought the technique to do this would come in handy but didn't think it was very straight-forward. So, I created some kind of tutorial for myself, writing the process down step-by-step. And it includes a working, tough very simple, example. See attached.
Zdenek_Moravec Not too long ago, similar questions came up on this forum. Both were responded to by
Thought the technique to do this would come in handy but didn't think it was very straight-forward. So, I created some kind of tutorial for myself, writing the process down step-by-step. And it includes a working, tough very simple, example. See attached.
Hi Riny_van_Eekelen, I am running into what I'm sure is a dumb mistake but I can't figure where I'm going wrong - I'm attempting this process but keep ending up with 3 tables instead of two when trying to follow your steps
1. "Create First Table (Source)" - Table 1
2. "Query it and load to...name (Source_2)" - Table 2
3. "Query table (Source_2), now including Notes" - Table 3
It seems that following the process I should only be ending up with two tables Source and Source_2, but again I keep ending up with 3 - Any help would be appreciated, thanks!
- Riny_van_EekelenJan 06, 2024Platinum Contributor
acemats Difficult to help without seeing what you are doing. Can you share a link (Onedrive or similar) to you file?