Skip to main content
Question

How do I replicate the 'not obj' function from MapInfo in FME 2018

  • April 25, 2019
  • 2 replies
  • 35 views

jez
Participant
Forum|alt.badge.img+1

Hi, I have a MapInfo tab file which contains around 390,000 features some of the features are not displayed in the Map window. After some investigation it appears that tab file contains some features that are ‘not objects’. I’ll call this ‘spurious data’. My current process to remove the spurious data is to use SQL Select and apply the condition 'not obj' (see screen shot below). This identifies around 14,000 features which can then be removed.

I naively thought, as the spurious data apparently has ‘no object’ and cannot be displayed in MapInfo , FME would automatically identify these features in a similar way and somehow inform me, at which point I'd use the relevant transformer to remove them. Unfortunately in this case FME reads all the data as valid data and when I attach an inspector it displays all the features !?!

Could someone please advise me on what transformer and / or parameter I need to use to stop features which are not objects to be removed?

Screen shot below shows how simple MapInfo performs the task:

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.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • April 25, 2019

It's been a few years since I used Mapinfo but if not obj is the same as null geometry you can use a geometryfilter to remove the null rows


jez
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • April 25, 2019

It's been a few years since I used Mapinfo but if not obj is the same as null geometry you can use a geometryfilter to remove the null rows

Thank you very much for your quick and successful reply. This works perfectly!