Question

NullValueMapper: testing for NOT Empty

  • 13 March 2015
  • 8 replies
  • 50 views

Badge +3
...Firefox works better for posting apparently...im using it now.

 

 

Anyway, you might have understand the question by now.

 

Is it not possible to test for empty strings in the NullValueMapper?

 

NullValueMapper is enticing me to use it to find a way to update Parameters, but it only tests for values or "Null/Empty/Missing"..but not "NOT Null/Empty/Missing".

 

 

Can i assume this not possible then?

 

 

8 replies

Userlevel 2
Badge +17
Hi Gio, how's this?

 

Userlevel 2
Badge +17
The StringReplacer (using regex) could also be used.

 

And, the Tester may be the easiest way to check if an attribute is not empty/null/missing. The != operator interprets both <null> and <missing> attribute to an empty string when comparing the operands.

 

attr != <leave blank the Right Value column>
Badge +3
Actually i was trying to update a parameter...not an attribute

 

As this transformer let's you choose one in the "selected Attributes" when the Map is set to "selected Attributes".

 

 

I was surprised so i had to try, but it does not appear to want to update any parameter you choose.

 

No matter what regexp you try.

 

 

If you choose a attribute, it works, but that was not what i was asking.

 

 

So i wonder why is there an option to choose a Parameter to map?

 

 

 

 
Userlevel 2
Badge +17
You can check if a parameter value is empty or not with the Tester, but I don't think its value can be updated with any transformer.
Badge +3
yes, i know.

 

 

but as one can choose "parameter" in the "selected Attributes" when the Map is set to "selected Attributes" , i was qurious if it might be possible after all.

 

 

So again:why is there an option to choose a Parameter to map?
Userlevel 2
Badge +17
maybe I finally got your question point.

 

 

I cannot answer to your question straight, but I know a usage of Parameter for the Selected Attributes. That is, to get "attribute list" through a published parameter in a custom transformer.

 

As far as I know, that's the only usage.

 

 

Try creating a published parameter in a custom transformer definition.

 

 

Badge +3
Yes, i have seen the AttrLlist question some days ago.

 

 

But i don't think it is logical to place it in a Mapping section. In the AttrList use it is more a parameter in wich is searched, and if found a attribute is subsequently mapped. Not a parameter.

 

It should be under "parameter to search in" or "mappingparameter" and not under attributes to match.
Userlevel 2
Badge +17
There are some transformers which have "attribute list" type parameter similar to the NullAttributeMapper. e.g. AttributeTrimmer, StringCaseChanger, StringFormatter, StringReplacer etc.

 

These transformers will manipulate attribute values through attribute names specified by the parameter, and also the parameter can be set to a user parameter.

 

Comparing to these transformers, I cannot find something conceptually special in the NullAttributeMapper...

Reply