I have a workspace with an Excel Reader and I want to change it to read a new version of the file. I can run the workspace with the new file and features are read in, but the resulting output contains blank values. How can I fix this?
Question
Using an updated version of my Excel File in a workspace doesn't produce results
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.
+13- Safer
There is a setting under Advanced when setting up the Reader Parameters called "Scan Schema in Dynamic Workflow". Checking this should allow you to use different copies of the file with the same workspace. Check out the Excel reader documentation for more on that.