Skip to main content
Solved

Tester appears to be missing some Nulls


jeovis
Contributor
Forum|alt.badge.img+2

I have an SDE Geodatabase (ArcObjects) data source and want to filter out all features with no name.

I've used a tester with a test for 'has a value'.

I've also tried testing for 'not null AND not emtpy string'

I've also tried using a NullAttributeMapper and mapping Nulls to some value and testing for that.

Whatever I do, 49 'Nulls' make it through to the output, even if I add more testers. Workspace obviously doesn't think these are Null/empty, but the inspector reports them as <null> after running the workspace.

I can just manually delete these from my output later, but if anyone can shed some light on what is happening here, I'd appreciate it.

I'm using Workbench 2016.1.1

edit:

if I query the oracle view in the geodatabase

select name, road_type from PLAN.roads_src where name is not null order by name;

I get a number of results with <NULL> for name.

So it appears FME is doing exactly what it is asked. So I guess not an FME issue, but still if anyone has some idea what is going on here...

Best answer by jeovis

Sorry folks, it turns out the name field actually had a string value of '<Null>'. Not null at all but that actual 6 char string.

View original
Did this help you find an answer to your question?

5 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • August 12, 2016

If the source attributes datatype is CHAR the attribute might have been filled with spaces. Have you tried the AttributeTrimmer to remove spaces (with the option to trim to Null) before testing on "has a value"?


mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • August 12, 2016
The Logger is a good transformer here - perhaps better than the Inspector as it just shows exactly what Workbench sees the feature as. So add a Logger before and after the Tester and check one of the features.

 

 


jeovis
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • August 12, 2016
erik_jan wrote:

If the source attributes datatype is CHAR the attribute might have been filled with spaces. Have you tried the AttributeTrimmer to remove spaces (with the option to trim to Null) before testing on "has a value"?

 

I did try that, thanks for the suggestion. I sorted it out, I will post the answer...

 


jeovis
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • Best Answer
  • August 12, 2016

Sorry folks, it turns out the name field actually had a string value of '<Null>'. Not null at all but that actual 6 char string.


nielsgerrits
VIP
Forum|alt.badge.img+54
jeovis wrote:

Sorry folks, it turns out the name field actually had a string value of '<Null>'. Not null at all but that actual 6 char string.

Thanks for sharing, made me smile. Have encountered a similar problem a while ago, these jokes can take far too long to solve.

 

 


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