If I understand correctly you want to do this dynamic? So input to be defined? One way to do this is to use an AttributeExploder. This will return a feature for each cell with _attr_name and _attr_value. Then you can test for all records where _attr_value has no value. Then merge the results with an Aggregator and merge that back to the original row to shift features with values from features with no values. Be aware that this is memory intensive when having a lot of features and a lot of attributes.

Expanding on @nielsgerrits​ response, in the AttributeExploder you can use the Exploding Type of List which will put your attribute names and values into a consolidate list on the original features. You will need to use the Ignore Attributes Containing parameter to ignore fme format attributes, and any other attributes you aren't testing for (this is a regex input). After the AttributeExploder, you can use a ListConcatentor (making the Separator Character parameter blank). If your test attributes are null, the concatenated attributed from the ListConcatentor will be blank, which can easily be tested for in a Tester or TestFilter.

Yes, using the list is a far better solution. ListElementCounter instead of ListConcatenator might be quicker an will work as well.

@nielsgerrits​ @dustin​ I feel bad, since I found another solution so only features are read from the first worksheet from excel. I found it based on the following

post.

Using two FeatureReaders and one Sampler in between. I used the followings settings for the sampler and the 2nd FeatureReader with a Constraint based on Features Type to Read: fme_feature_type_name. Now only feature from the first worksheet are read. Since @dustin​ answer is actually more the answer to my question (how to remove Null values), I will select that post as "Select as Best"

Can anyone give more detaild information concerning the configuration of these three transformers, in order to make this workflow work? This seems to be the answer to one of the challanges i tackle at the moment, as well.

I tried to deal with this from a different approch, using a Scriped Value (python) User Parameter as configuration-input (Attributes to Remove) for an “Attribute Remover”, but unfortunatly it did not work out. I’d be very thankful about thoughts on that aswell.

I tried to implement dustins solution for some time now. But i seem to do something wrong. I would be very thankful, if someone could give detailed Information about the configuration of the Attribute Exploder, the List Concatenator and the Tester/Test Filters Parameter-Configuration.

My Goal also is, to remove all Attributes, which contain nothing but Null and empty Values, for my output Data to be left with only relevant attributes.

Hi ​@woelfl, 

I’ve attached a simple workspace illustrating what I believe was described by dustin & nielsgerrits​. I hope that this serves as a good starting point if you’re looking to dynamically filter out any null values from your dataset. If you don’t need to do this dynamically (ie your schema is the same every time) then you can also simplify things by using just the AttributeValidator instead (I’ve also included this as an option in the attached workspace). 

I hope this helps and please let me know if you have any questions! 

Hi ​@joy AttributeValidator Transformer will be able to solve the issue for you.

Hi ​@saraatsafe, thank you very much. this helps a lot!