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
I wanted to create a column and populate it with data based on data from other fields.
If column_1 contains fields which has similar string (eg. field_1 = "Country: UK", field_2 = "Country: US", field_3 = "City: London"), is there an expression to update fields which ONLY contain part of the string - in this case "Country"?
This is connected to a related question I asked earlier: Create and immediately update field using Field Calculator
Following on from Matthias' answer, this expression allowed me to add a filter and populate NewColumn in just one step:
case when "column_1" ILIKE '%Country%' then 1
else 0
end
