Skip to main content
  • EN

Hello, 

I have 4 excel documents hosted on SharePoint, I am using a FeatureReader taking in a temp download path. 
 

As can be seen the 4 items are being opened successfully in the featurereader, but the data is not grouped in any meaningful way for me to extract and sort out the various excel documents data (which is varying formatting, some have multiple tabs with differing data/headers between them, as you can see there are 14 schemas (total tabs within excel docs), and 1546 generic bits of data (total rows))


I’ve read that I can re-group the datasets by using fme_basename but I cannot work out how to expose this, I’ve found the post below, which offers suggestions of how to expose that data. But the solution it offers is not applicable, I am using version 


 



Does anyone know how I can expose the fme_basename?

OR

Is there a better way to do this?

 

 

 

 

 

I’ve found a solution to exposing the fme_basename.

tools->edit headers, add: “READER_META_ATTRIBUTES fme_feature_type fme_dataset fme_basename” without quotes. 

see link below
 


Also this link might be useful for anyone else who finds this question, and how to sort the items out afterwards:

 

2nd link: https://community.safe.com/transformers%2D9/how%2Dto%2Dread%2Dattribute%2Dnames%2Dfrom%2Dmultiple%2Dexcel%2Dworkbooks%2Dsheets%2Dto%2Dnew%2Dworkbook%2D27011 wasnt that useful, instead to finish off my workflow I used fme_feature_type (exposed using instructions above) combined with attribute exposer to expose the items I needed.

 

Community Stats

31,758
Posts
120,641
Replies
39,382
Members

Latest FME

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.