I am trying to compare the values of 2 fields in my attribute table and update a 3rd field as a result. In the field calculator I have
CASE when (("Address") like ("COUNTYNAME" )) then 'Match'
else 'Error'
End
so for the following toy data examples I would get the result Match,Error,Error Address,COUNTYNAME
- Smith, Smith County
- Bob, Smith County
- Jane, Bob County
I have also tried CASE when (("Address") IN ("COUNTYNAME" )) then
Are there any other ways to compare text values within QGIS?