Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I have an attributetable with several columns.
I want to change the values of column1 if they are NULL with the values of the same row in column5.
case WHEN column1 is NULL THEN
How do I say "use the value from the same row"?
The field calculator always calculates on a row-by-row basis. So you can use:
CASE WHEN "column_1" IS NULL THEN "column_5"
You can also use coalesce to replace NULL values from column_1 by column_5.
Open the attribute table and make it editable.
Select by expression "column_1" isnull
Along the top of the attribute table you an select in a drop down a column of
your choice. Select "column_1"
In the text box available write "column_5"
Click "Update Selected"
Required, but never shown