Skip to main content
Question

How can I fix an issue with Excel Reader writing values in column as missing

  • June 15, 2022
  • 1 reply
  • 32 views

I'm reading an Excel file using the Excel Reader. The reader works well for all fields except one. It consistently marks all the values in a particular numerical column 'Number of meters' (column G of each sheet) as missing. The file is open data but a copy has been attached for convenience: https://www.gov.uk/government/statistics/lower-and-middle-super-output-areas-gas-consumption image

1 reply

geomancer
Evangelist
Forum|alt.badge.img+58
  • Evangelist
  • 932 replies
  • June 15, 2022

I cannot reproduce this problem (FME 2020.0)

LSOA_Domestic_2LSOA_Domestic_1