Forum Discussion
Solved
Issue with Merge giving null result
Hello, I am having an issue again with merge.... I have a query which has been been heavily transformed, which I want to merge to another through a key column. Issue is - when I have the same text ...
Hello, I found the issue! It was in my referenced query - there was an issue with the M code, which was removing some older dates. So when I was filtering for the instance only at the beginning of the referenced query, it was working. When I tried to filter for it at the end of the referenced query instead, I found that it was gone because of some filtering in previous steps. All good now 🙂 Thanks!
It may be helpful to take just your ke columns, append them into just one column, then Remove Duplicates. This should show you if the values really match. If you see your value twice (sort the column), then you have non matching values.
--Nate