Skip to main content
Question

unable to get attributemanager to recognise attribute is null


Forum|alt.badge.img+1

I am trying to use a conditional statement to update an attribute if it is null with the value of another attribute .

However AttributeManager does not recognise the null or empty string .

it does not work if I change the output to text or @Value(CaseOfficer) either.

What am I missing here?

 

7 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • January 2, 2020

Are you sure the value is actually null? If you inspect in the data inspector does it show like this


Forum|alt.badge.img+1

In the sql database it is null but in Fme it appears as <missing>


erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • January 2, 2020

In these cases I usually use the "Attribute has a Value" option and negate it.

That will also exclude the missing attributes (next to empty or null).


Forum|alt.badge.img+1

This worked - Thanks


ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • January 2, 2020
lizzygradidge wrote:

This worked - Thanks

It may be worth checking that the sql database is being read correctly, you shouldn't be seeing the attribute as missing if it exists.


Forum|alt.badge.img+1

the "Attribute has a Value" option and negate it. also works

Thanks again

Lizzy


Forum|alt.badge.img+1
lizzygradidge wrote:

This worked - Thanks

how do i check the sql database is being read correctly?


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