Forum Discussion
Solved
Power Query Merge Multiple workbooks in a Folder
Hi all, Apologies, if this question has been posted before but I am new to Power Query and I am still learning as I go along. I have searched Google and watched various tutorials but I couldnt f...
To resolve my issue I duplicated the process of converting the sample file to 2 seperate processess instead of trying to combine the 2 into 1 merged step.
After this I then merged the 2 new process to the new workbook to create a consolidated report.
Anonymous wrote:Did you try the merge or append option ?
I duplicated the sample file and renamed them "TBL (1)" and then "TBL (2)" and MERGED them to create "Merge_TBL 1&2".
When I click on "SPAR data Allocation" it only shows the applied steps I did in "TBL (1)".
What I am trying to accomplish is for "SPAR data Allocation" to use the steps in "Merge_TBL 1&2" to apply to all the files.
Did you try merge as new ?
Anonymous wrote:Did you try merge as new ?
to create "Merge_TBL 1&2" i did merge as new.