Question

Transforming a point dataset from a flat file (TXT) to MapInfo Extended TAB results in complete data loss in a particular field

  • 3 June 2021
  • 1 reply
  • 0 views

Badge

I have 4 datasets of 10 million rows each in a delimited TXT format that I am trying to transform to a MapInfo Extended TAB (point dataset).

While 2 of the files transformed without issues, the other 2 were observed to have lost values for a particular field completely. This field is supposed to have a 5 digit numeric value but was left completely blank in the extended tab output.

The FME log did not contain any warning and suggested that the transformation was successful.

Could you please help us root cause the issue and suggest ways to avoid such data loss ? Thanks.


1 reply

Badge +2

@raghunaren​ if you could attach a small sample of the data someone would be able to track down why you are missing the attributes. The lost likely cause is that the integer values are larger than they int type set on the MapInfo Writer Feature Type.

Reply