Skip to main content
Solved

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

  • June 16, 2023
  • 1 reply
  • 90 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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

ctredinnick
Supporter
Forum|alt.badge.img+19
  • Supporter
  • 225 replies
  • 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