Skip to main content
Question

unable to get attributemanager to recognise attribute is null

  • January 2, 2020
  • 7 replies
  • 120 views

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?

 

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.

7 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • 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
  • Author
  • 31 replies
  • January 2, 2020

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


erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • 2179 replies
  • 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
  • Author
  • 31 replies
  • January 2, 2020

This worked - Thanks


ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • January 2, 2020

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
  • Author
  • 31 replies
  • January 2, 2020

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

Thanks again

Lizzy


Forum|alt.badge.img+1
  • Author
  • 31 replies
  • January 2, 2020

This worked - Thanks

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