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
case WHEN column1 is NULL THEN END
How do I say "use the value from the same row"?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
The field calculator always calculates on a row-by-row basis. So you can use:
CASE WHEN "column_1" IS NULL THEN "column_5" ELSE "column_1" END
You can also use
coalesce to replace
NULL values from