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
Question
Google Sheet Columns not reading in Reader
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.
+47- Celebrity
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.