I don't know how to filter the attribute table in qgis. I have 2 columns, DN and DN_1, both with values from Corine Land Cover (111,112, 223, etc). I try to select the rows that have the same value. For example. DN: 111, and DN_2: 111, to erase them, and have only values that are different on the same row. Is there a way to filter this?
filter by expression with
"DN"="DN_2" ? depending on the column type (string/integer) you could also try an :
Another solution via using
Since the match has to be checked both ways means the
regexp_match() has to be applied twice using the conjunction
AND to achieve the exact match.
regexp_match(trim("DN"), trim("DN_2")) AND regexp_match(trim("DN_2"), trim("DN"))
A Λ B is true only if
A is true and
B is true
Returns true if any part of a string matches the supplied regular expression
input_stringthe string to test against the regular expression
regexthe regular expression to test against
Removes all leading and trailing whitespace (spaces, tabs, etc) from a string