Forum Discussion
Solved
Replace Null Values and If
Hello, I am a novice user of PQ. What I want to do is: change where [Budget Category] = Null and if [Vendor] = "Co A" then change [Budget Category] to "A" and if [Vendor] = "Co B" then change [...
Better use a reference table, and a custom join/lookup . No need to hard code this.
Hi Antrik,
thank you for the response. Interesting approach. I am a novice user and I'm not a programmer and I don't really understand what the code is doing, but I do not see how it is making the required changes. Thank you
Hi Centaur , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.