Forum Discussion
Solved
Replacing all non-null values
This is probably a fairly simple query, but I cannot work out how to do it. How can I replace all values that are not null across multiple columns with the word Yes. Thank you!
Sorry.
Then I would probably add a conditional column
IF [column] = null then NULLELSE [column]
This calculated column will have your cleaned up values. Then you can hide the original one.
As far as I know the "Replace value" function does not have what you need.