Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
3 years ago
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 ...
Need Help
  • ValeriaBreve's avatar
    ValeriaBreve
    3 years ago

    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!

     

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
3 years ago

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!