Power Query Merge Issue missing Data

daleholden

Board Regular
Joined
Sep 22, 2002
Messages
235
[FONT=&quot]Hi Guys[/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]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 !!![/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]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.[/FONT]

[FONT=&quot]
[/FONT]

[FONT=&quot]Code is HERE[/FONT]
[FONT=&quot]
[/FONT]

[FONT=&quot]Images HERE[/FONT]
 

daleholden

Board Regular
Joined
Sep 22, 2002
Messages
235
I fixed it with
[FONT=&quot]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.[/FONT]
[FONT=&quot]I re did the filter and now it works again.[/FONT]
 

Forum statistics

Threads
1,084,744
Messages
5,379,571
Members
401,613
Latest member
KarimK9

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top