Results 1 to 4 of 4

Thread: Power Query Merge Issue missing Data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2002
    Location
    North West UK
    Posts
    235
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Power Query Merge Issue missing Data

    Hi Guys
    I need some help with a PQ Merge issue i have to tables that i merge with the simple idea via a SKU it collects Categories from another table. All SKU's are present and the Cats are also listed. THis worked but when i add new items the Categories are not being picked up.
    I have added images and the PQ M Code to help i was trying to copy the sheet s to a new work book as i cannot link to my live sheet for obvious reasons but he copy will not let me due t key issues !!!
    I have tried a few different joins but they have not helped. If you need any more info please contact me.I cannot work out why it is not picking up the Categories this kind of merge is what PQ is supposed to be good at.
    So i guess i have missed something fundamental but i cannot see it. THe top 3 SKUs show in the code i have checked and are in both sheets with CAT's listed?

    If you know how i can create a copy please let me know. I used copy to other workbook all the relevant sheets.



    Code is HERE


    Images HERE
    People prefer to follow those who help them, not those who intimidate them.

  2. #2
    Board Regular
    Join Date
    Sep 2002
    Location
    North West UK
    Posts
    235
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Merge Issue missing Data

    Self Solved
    People prefer to follow those who help them, not those who intimidate them.

  3. #3
    Rules violation
    Join Date
    Jan 2012
    Posts
    912
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Merge Issue missing Data

    Why don't you post your solution for the record?

  4. #4
    Board Regular
    Join Date
    Sep 2002
    Location
    North West UK
    Posts
    235
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query Merge Issue missing Data

    I fixed it with
    I had a filter set in PQ on one of the queries to filter out 0 Qty but when trouble shooting it also had several other low values unchecked.
    I re did the filter and now it works again.
    People prefer to follow those who help them, not those who intimidate them.

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
  •