Skip to main content
Question

Remove Attributes that contain all nulls

  • June 13, 2018
  • 3 replies
  • 306 views
oliver.morris
Contributor
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+22
  • erik_janContributor
  • Contributor
  • 2179 replies
  • 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+14
  • oliver.morrisContributor
  • Author
  • Contributor
  • 176 replies
  • 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+14
  • oliver.morrisContributor
  • Author
  • Contributor
  • 176 replies
  • 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.

Community Stats

32,085
Posts
121,845
Replies
39,727
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility 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.