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.
+19- Contributor
- 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.
takashi wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.