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
Thank you V. Appreciate the follow up confirming most efficient approach. I dont know exactly how to implement but I think i can figure it out. I might need to check a youtube video. This is my go to "advisor". I plan to tsckle today or the weekend. Thank you again for the response.
Hi Centaur , Thanks for the update. Always happy to help.