Forum Discussion

Fuisdale2's avatar
Fuisdale2
Frequent Visitor
4 years ago
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...
Need Help
Tutorial Requests
  • Fuisdale2's avatar
    Fuisdale2
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

Did you try the merge or append option ?

  • Fuisdale2's avatar
    Fuisdale2
    Frequent Visitor
    4 years ago
    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Did you try merge as new ?

      • Fuisdale2's avatar
        Fuisdale2
        Frequent Visitor
        4 years ago
        Anonymous wrote:

        Did you try merge as new ?

        to create "Merge_TBL 1&2" i did merge as new.