Skip to main content
Solved

How to extract data from multiple excel docs with varying formatting using FeatureReader

ecx
Contributor
Forum|alt.badge.img+4
  • ecxContributor
  • Contributor

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?

 

 

 

 

 

Best answer by ecx

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:

 

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

2 replies

ecx
Contributor
Forum|alt.badge.img+4
  • ecxContributor
  • Author
  • Contributor
  • Best Answer
  • February 5, 2025

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:

 

DanAtSafe
1 person upvoted this
  • DanAtSafe
    DanAtSafe
ecx
Contributor
Forum|alt.badge.img+4
  • ecxContributor
  • Author
  • Contributor
  • February 5, 2025

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.

 

Most helpful members this week

Community Stats

30,845
Posts
116,926
Replies
38,664
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.