Forum Discussion
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 ...
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
Thank you SOOOO much, that was indeed the issue. It's fixed and I'm doing a happy dance!!