Forum Discussion

tgjones43's avatar
tgjones43
Helper IV
7 years ago
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!
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Sorry.

     

    Then I would probably add a conditional column
    IF [column] = null then NULL

    ELSE [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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

In the query editor,select your column. Then on the Transform tab on top choose Replace values and select "null" with "yes".
Repeat for every column

tgjones43's avatar
tgjones43
Helper IV
7 years ago

Thanks, but I want to leave the "null" values as "null". It is all the other values that I want to replace with "Yes". There are thousands of different values, all of which need to be "Yes".

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Sorry.

     

    Then I would probably add a conditional column
    IF [column] = null then NULL

    ELSE [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.