Skip to main content
Solved

How to COUNT total number of NULL values for EACH records ?

  • June 16, 2023
  • 1 reply
  • 74 views

vimva679
Supporter
Forum|alt.badge.img+9

As an eg. there are 4 records i wanted to check how many null values are present for each records .

image

Best answer by ctredinnick

Use an attribute exploder to split every attribute into a name/value pair. Then a Tester, to test that attr_name is the attributes you care about, and attr_value is null. Then Aggregator with Group By your ID, the number of features in the aggregation will be the count of null attributes.

image

View original
Did this help you find an answer to your question?

1 reply

ctredinnick
Supporter
Forum|alt.badge.img+18
  • Supporter
  • Best Answer
  • June 17, 2023

Use an attribute exploder to split every attribute into a name/value pair. Then a Tester, to test that attr_name is the attributes you care about, and attr_value is null. Then Aggregator with Group By your ID, the number of features in the aggregation will be the count of null attributes.

image


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings