Skip to main content
Question

Keep records with less null values per category

  • March 20, 2026
  • 1 reply
  • 16 views
katta
Participant
Forum|alt.badge.img+1

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
    Influencer
    Forum|alt.badge.img+47
    • ebygommInfluencer
    • Influencer
    • March 20, 2026

    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,370
      Posts
      123,054
      Replies
      40,452
      Members
      Terms & ConditionsCookie settingsAccessibility 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.