Timeline for Identifying duplicate attributes in field using QGIS
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 22, 2022 at 9:47 | comment | added | she_weeds |
@panoet This is because it doesn't matter what field we aggregate for count() here, the important thing is what attribute it is grouped by (i.e. the attribute that we want to find duplicates in). In this case there is no difference if it is counting TreeID (for the five features above - T1019; T1020; T1021 + T1021; T1021 + T1021; T1023), or the value 1 (1; 1; 1+1; 1+1; 1), the count of values is still 1; 1; 2; 2; 1
|
|
| Feb 27, 2022 at 19:13 | comment | added | panoet | What is the use of "1" in the first argument? According to QGIS documentation, it is the expression which is field to aggregate. Why do we put "1"? | |
| Aug 4, 2021 at 1:45 | history | edited | she_weeds | CC BY-SA 4.0 |
updated to use simpler expression
|
| Jul 15, 2020 at 15:13 | comment | added | onietosi | As suggested by @caiohamamura, the expression can be slightly simplified to: count(1,"FieldWithDuplicates") > 1 | |
| Jul 15, 2020 at 12:19 | review | Suggested edits | |||
| Jul 15, 2020 at 14:43 | |||||
| S Feb 3, 2020 at 10:26 | history | suggested | onietosi | CC BY-SA 4.0 |
clarify meaning of "FieldWithDuplicates" and corresponding field in image
|
| Feb 3, 2020 at 9:59 | review | Suggested edits | |||
| S Feb 3, 2020 at 10:26 | |||||
| Jul 15, 2019 at 8:47 | comment | added | she_weeds | @maxwhere , do you mean in the Query Builder used for filtering layers? I can't seem to get it to actually filter the results in Q 3.4 or 3.8, although I'm surprised it didn't throw up an error like it used to in Q 2.x. | |
| Jul 4, 2019 at 9:50 | comment | added | maxwhere | This is by far the most legit answer here. I just wanted to add that the expression can be used directly with the standard query tool as well. | |
| Jul 26, 2017 at 7:17 | review | Late answers | |||
| Jul 26, 2017 at 7:29 | |||||
| Jul 26, 2017 at 6:59 | history | answered | she_weeds | CC BY-SA 3.0 |