Share via

Why are related data not showing up despite the reference columns/values match in Power query Merge?

Antonio Santos 1 Reputation point
2021-05-24T16:04:57.15+00:00

Hi,
I have joined these two tables, related them by a PO number. The PO number exists in both of the tables, but the left one shows most of its values as null, despite the PO number is there?
Clumn Name is PEDIDO

99164-capturar.png

Here's the output:
99232-capturar.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,794 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz._ 8,991 Reputation points
    2021-05-24T16:37:04.103+00:00

    Hi @Antonio Santos

    I would suspect trailing space(s) in the key column ([PEDIDO]) either in one of the tables or in both

    To check (do this on both tables): when you're the Power Query Editor > Right-click [PEDIDO] > Transform > Trim. Then try to merge again..