Hi,
I have a workspace set up to convert excel files to geodatabase feature classes with the sheet names being preserved in the output. I'm wondering if there's a way to preserve the actual excel file name instead?
Thanks!
Solved
Is there a way to preserve the file name not the sheet name: converting excel files to geodatabase feature classes
Best answer by takashi
Hi @badams, try exposing "fme_basename" or "fme_dataset" in the Format Attributes tab of the Excel reader feature type. "fme_basename" will contain the source file name without extension; "fme_dataset" will contain the source file path.
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.
- Best Answer
Hi @badams, try exposing "fme_basename" or "fme_dataset" in the Format Attributes tab of the Excel reader feature type. "fme_basename" will contain the source file name without extension; "fme_dataset" will contain the source file path.
Hi @badams, try exposing "fme_basename" or "fme_dataset" in the Format Attributes tab of the Excel reader feature type. "fme_basename" will contain the source file name without extension; "fme_dataset" will contain the source file path.