Question

Google Sheet Columns not reading in Reader

  • 22 October 2019
  • 1 reply
  • 8 views

i'm getting probelm i google sheet .. everything is OKay but when i connect the sheet some columns are coming and some are not showing in transfrmr pleae anyone can help me out


1 reply

Userlevel 4
Badge +26

If the Reader was added and new columns were added after the Reader was added you might want to try ReAdding the reader.

 

What might be happening (and is a fairly common problem) is that when you first add a Reader FME will scan the data and create a schema based on that data/those columns. If you then add new columns but don't Re-add the reader (or update the feature type) then FME doesn't know about the new columns.

 

 

Try deleting and Re-adding the Google Sheets Reader.

 

Another possible issue is that you have defined the Reader based on a 'Named Range' where the Named Range contains some, but not all, of the columns. Check that if reading a Named Range that the columns which are missing are contained in that range.

Reply