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.
+12- Contributor
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.
+2pratap wrote:
I think this is internal value of MapInfo. Pass "0" instead of null
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.