Skip to main content
Question

Remove Attributes that contain all nulls

oliver.morris
Supporter
Forum|alt.badge.img+14

Is there a way to quickly remove all attributes that contain no data, i.e. every row is null.

I don't really want to run a python script, I am wondering if I can to some statistics to count and then something to remove the attribute.

Many Thanks,

Oliver

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.

3 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • erik_janContributor
  • Contributor
  • June 13, 2018

You can use the NullAttributeMapper to do this:

Use the settings:

If attribute is Null then Map to Missing.

    oliver.morris
    Supporter
    Forum|alt.badge.img+14

    Hi, thanks for the quick reply @erik_jan

    Using this just turned the attributes to missing and not null, how do I actually remove the column/attribute?

    Many Thanks

    oliver.morris
    Supporter
    Forum|alt.badge.img+14

    ok, I was hasty, on pulling this out to JSON format all the attributes now marked as missing are not included.

    Excellent, thank you.

    Community Stats

    32,974
    Posts
    124,970
    Replies
    41,874
    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.