Hi,
MapInfo writer is populating -9999 to attributes which have been manually set as integer or float and is empty. Cant figure out why?
Thanks,
Ashish
Solved
Mapinfo writer populating -9999 to empty integer records
Best answer by david_r
Unfortunately the MapInfo format doesn't support NULL values.
FME will automatically substitute NULL values as follows when writing to a Mapinfo dataset:
- NULL written to a numeric column becomes -9999
- NULL written to string column becomes an empty string
You can use the NullAttributeMapper set to map to "New value" if you need other NULL substitutes.
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.
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.
+14- Supporter
Hi @ashish_m1,
Those values mean that there is no value which does not mean it is a zero. You can use the Tester transformer for a Null values and set them as zero, but this is not correct in my point of view. Otherwize just leave the -9999, other software should have the capability to ignore that specific -9999
I hope this helps.
Lyes
- Best Answer
Unfortunately the MapInfo format doesn't support NULL values.
FME will automatically substitute NULL values as follows when writing to a Mapinfo dataset:
- NULL written to a numeric column becomes -9999
- NULL written to string column becomes an empty string
You can use the NullAttributeMapper set to map to "New value" if you need other NULL substitutes.
+2I think this is internal value of MapInfo. Pass "0" instead of null