Is there some setting that needs changed?
Solved
I've found that when providing an excel worksheet name via the initiator for the feature reader transformer, it can't find a sheet that has spaces in its name i.e. 'as at 30Nov20', but it can find the same sheet if I rename 'as_at_30Nov20'.
- Participant
- 1 reply
Best answer by nielsgerrits
Because of the spaces, you need to put the sheet name between quotation marks. So instead of
as at 30Nov20you have to use
"as at 30Nov20"
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.
+60- 2938 replies
- Best Answer
Because of the spaces, you need to put the sheet name between quotation marks. So instead of
as at 30Nov20you have to use
"as at 30Nov20"
@garyhk Thanks for raising this issue. @nielsgerrits has given you a workaround, but this is something we'll try and fix in a future release.
- Participant
- 1 reply
Thanks for the replies especially @nielsgerrits. Using a stringconcatenator to add double quotes has fixed the issue for me.