Skip to main content
Solved

EXCEL-reader: Read transposed EXCEL

  • January 9, 2014
  • 1 reply
  • 19 views
sigtill
Supporter
Forum|alt.badge.img+24
On several projects they have made the Excel-spreadsheets "non logical".  So instead of having the spreadsheet like this:

 

 

 

 

Is is saved as this:

 

 

 

I have read the various FME + transpose + EXCEL posts (for instance http://fmepedia.safe.com/articles/How_To/Advanced-manipulation-of-Excel-tables-using-AttributeExploder) - however this will not give me access to the schema withouth running a workspace first - and then loading that file in a new workspace.

 

 

So it would be very usefull to have a "read transposed" option on the EXCEL-reader. Or is there a workaround I havent found?

 

 

 

 

Best answer by kathyross

Have you seen the following articles:

 

https://community.safe.com/s/article/pivot-table-using-fme

 

https://community.safe.com/s/article/pivoting-between-columns-lists-and-records

 

 

View original
The real SigTill
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.

1 reply

K
Forum|alt.badge.img+4
  • kathyross
  • Best Answer
  • February 3, 2014

Have you seen the following articles:

 

https://community.safe.com/s/article/pivot-table-using-fme

 

https://community.safe.com/s/article/pivoting-between-columns-lists-and-records

 

 

Helpful Members This Week

Community Stats

31,317
Posts
118,810
Replies
38,946
Members

Latest FME

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.