Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • Is there a way to preserve the file name not the sheet name: converting excel files to geodatabase feature classes

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!

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.

Worked perfectly! Thanks so much @takashi

Reply


Community Stats

30,102
Posts
114,261
Replies
37,734
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.