Merge queries not returning matches

Thank you SOOOO much, that was indeed the issue. It's fixed and I'm doing a happy dance!!

Hi Jiv,

Power Query supports text strings of up to 32,766 (unicode) characters, so I don't think that's the issue.

In my experience, it's usually one of the following fixes, in rough order of likelihood:

-1- Refresh the result preview by going to the Home tab > Refresh Preview

-2- Trim the matching columns in both tables (Transform tab > Format > Trim)

-3- Upper- or lower-case the matching columns in both tables (Transform tab > Format > UPPERCASE or lowercase)

-4- Clean the matching columns in both tables (Transform tab > Format > Clean)

I've not listed matching the Data Types as the Merge dialog should give you a warning for this.

If none of these work, then you'll need to provide a small amount of anonymised sample data from each matching table to see if the issue can be reproduced and fixed accordingly.

Pete

Thank you for your time!!

None of the tips did the trick... here's what my data looks like. I'm trying to merge using the column "DD_REL".

Table A

Table B

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.