Hello,
Is there a way to extract the schema automatically from an Excel file when FME Server runs the scheduled workbench?
People who drops the Excel files doesn't change the fields though, only the sheet name.
Thanks.
Solved
Extract Excel schema automatically
+22- Enthusiast
- 329 replies
Best answer by david_r
If you use the FeatureReader rather than the reguler Excel reader, you'll get the schema feature as well as the data features. If you use a single output port, you'll be able to read any Excel file. And since the schema feature comes before the data features, you can analyze the structure of your Excel file before working on the data, e.g. verify the existence of certain fields etc.
Just remember that you'll have to manually expose the attributes in your workspace when using the single output port.
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.
- 8394 replies
- Best Answer
If you use the FeatureReader rather than the reguler Excel reader, you'll get the schema feature as well as the data features. If you use a single output port, you'll be able to read any Excel file. And since the schema feature comes before the data features, you can analyze the structure of your Excel file before working on the data, e.g. verify the existence of certain fields etc.
Just remember that you'll have to manually expose the attributes in your workspace when using the single output port.
+22- Enthusiast
- 329 replies
It works great! I can't retrieve the fme_basename though. Even with the AttributeExposer. Is there another way?
+20- Safer
- 3719 replies
It works great! I can't retrieve the fme_basename though. Even with the AttributeExposer. Is there another way?
You will have to expose it in the excel readers parameters - you might still also need the AttributeExposer
