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
Better use a reference table, and a custom join/lookup . No need to hard code this.