Forum Discussion

mike_asplin's avatar
mike_asplin
Helper V
6 months ago
Solved

Very odd merge behavior in power Query

I have a look up table with a row for "Sales Enquiry" as below which is called Enquiry Status Reason Funnel     In my main table I am using this merge and expansion   #"Merged Queries6" ...
Need Help
  • mike_asplin's avatar
    mike_asplin
    6 months ago

    I did check for duplicates and the extra spaces. If it had no columns that would make sense.  As i said doing a complete refresh seemed ot clear its head and it was fine. Thanks for response.  

rohit1991's avatar
rohit1991
Super User
6 months ago

Hii mike_asplin 

 

Since one column expands correctly and others return null, the merge is partially matching but not fully resolving the lookup row.

Fix:

  1. In both tables, set join column explicitly to Text.

  2. Add a clean column for merge:

Text.Upper(Text.Trim([Enquiry Status Reason (CRM)]))

  1. Use this cleaned column in the merge on both sides.

  2. Refresh preview (sometimes Power Query cache holds old structure).

 

  • mike_asplin's avatar
    mike_asplin
    Helper V
    6 months ago

    I did a refresh and fixed itself before I tried your fix but much appreciated