Skip to main content
Question

Remove Attributes that contain all nulls


oliver.morris
Contributor
Forum|alt.badge.img+12

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

3 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • 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
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • June 13, 2018

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
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • June 13, 2018

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

Excellent, thank you.


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