Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Power Query Combine

  1. #1
    Board Regular
    Join Date
    Jul 2014
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query Combine


    Power Query Combine
    Hey all,

    I have a few report i extract daily and clean up in power query to give me a neat table with the data i need. Now as i have different markets i need to extract the same report multiple time for all markets. So the report structure does not change only the output data is from another market. Unfortunately there is no way to distinguish the different markets in the output report. Only when i rename them. So my question is:

    Can i combine two query's made in power query so i can use the data in one pivot table?

    I have noticed that i can combine tables in power query. But then when in say want to import that connection into a new file, the combined table is not shown in power query.

    Any help would be highly appreciated as this keeps me up at night

    Evil

  2. #2
    MrExcel MVP Ron Coderre's Avatar
    Join Date
    Jan 2009
    Location
    Boston, Massachusetts
    Posts
    2,285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Combine

    Can you run one query that includes each market and adds a "Market" column to the results? Then the pivot table could return a report for any market you want.
    Best Regards,

    Ron Coderre
    Microsoft MVP-Excel (2006 - 2015)
    Using: Excel 2013 & 2016

  3. #3
    Board Regular
    Join Date
    Jul 2014
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Combine

    Hey Ron,

    I need the data per day per hour. So in the tool i can filter various markets at one time, but the report will aggregate the info. So all volumes at 7 o'clock will be summed together. I was just wondering if i could add all the rows from one query to another as the structural are exactly the same..

  4. #4
    MrExcel MVP Ron Coderre's Avatar
    Join Date
    Jan 2009
    Location
    Boston, Massachusetts
    Posts
    2,285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Combine

    Without more details, I'd say: Yes...You can use Power Query's "append" feature to combine query results.
    Best Regards,

    Ron Coderre
    Microsoft MVP-Excel (2006 - 2015)
    Using: Excel 2013 & 2016

  5. #5
    Board Regular
    Join Date
    Jul 2014
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Combine

    Hey Ron,

    Let me try this :D

  6. #6
    Board Regular
    Join Date
    Jul 2014
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Combine

    Hello Ron,

    Thanks for your input. I could without much effort append the queries i wanted. Important was to keep headers and columns equal in all queries. It does show some inconsistency's. Example: I have one workbook with 3 tables in 3 sheets. Using Power Query to append them is no problem. I create connections from the 3 tables in the workbook and then append them to one and load to a table in the same workbook on another sheet that i hide. Idea is to use this table as a connection in other reports. Now when i want to connect to that table using power query in another report, the appended table does not show up when using Import data from a excel workbook. When i use 3 different workbooks and import them using PowerQuery into one workbook and then create the append table, i then can use this appended table to import in other reports... Very strange

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •