Forum Discussion

jivens's avatar
jivens
Regular Visitor
2 years ago
Solved

Merge queries not returning matches

Hi all,   I'm merging two tables in Power Query and it's not returning matches when I know there should be (my dataset is small at this stage and I can basically see the matches with the naked eye ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi Jiv,

     

    It looks like your TableA [DD_REL] column has a double-space before each of the '#1' parts.

    Try right-clicking on the TableA[DD_REL] column header and select Replace Values. Then replace "  " (double-space) with " " (single space), then do the merge after this step. That worked for me:

    Table.ReplaceValue(PreviousStepName, "  ", " ", Replacer.ReplaceText, {"DD_REL"})

     

     

    Pete

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jivens 

1.You can remove the space of the DD_REL column in two tables

Table A

Table B

 

2.Then combine the two table 

 

Output

 

You can refer to the attachment.

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.