Skip to main content
Question

Keep records with less null values per category

  • Mar 20, 2026 1:13 PM UTC
  • 1 reply
  • 36 views
katta
Contributor
Forum|alt.badge.img+3

Good day,

I have a table with a couple of records.

I would like to keep one record per category and this record should be the record which has the less attributes with a null (missing) value (I highlighted them in green on the screenshot.). How can I automatically calculate which record per category I should keep?

 

      1 reply

      ebygomm
      Evangelist
      Forum|alt.badge.img+54
      • ebygommEvangelist
      • Evangelist
      • Mar 20, 2026 1:28 PM UTC

      One possible way is to use the attribute validator to check whether attributes have values, count the resulting list which is in effect the number of missing values for a row and sort by this, and keep only the feature for each group that has the least number of blanks

       

        Community Stats

        32,990
        Posts
        125,025
        Replies
        41,912
        Members
        Terms & ConditionsAccessibility statement
        A product of
        Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.