Question

Remove Attributes that contain all nulls

  • 13 June 2018
  • 3 replies
  • 26 views

Badge +10

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

Userlevel 2
Badge +16

You can use the NullAttributeMapper to do this:

Use the settings:

If attribute is Null then Map to Missing.

Badge +10

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

Badge +10

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

Excellent, thank you.

Reply