Skip to main content
Solved

Excel - transposed attributes not output in correct order.

  • April 14, 2015
  • 1 reply
  • 16 views

I am trying to transpose the output of an Excel writer.

 

 

I have only 1 row of values to transpose perhaps there is an easier way? e.g

 

field1, field2, field3

 

vala, valb, valc

 

 

should become

 

 

field1, vala

 

field2, valb

 

field3, valc

 

 

 

I used the example Transpose2015.fmwt on http://fmepedia.safe.com/articles/How_To/Advanced-manipulation-of-Excel-tables-using-AttributeExploder.

 

 

However my output attributes are not ordered.  It appears the incoming order of the attributes is lost when the AttributeExploder is applied?

 

 

Is there an easy to resolve this or an easier method to achieve the same?  I had a brief look at the ListPivotDemo but am waiting for the database outage to be resolved before I can test.

 

 

Thanks,

 

 

Annette

 

 

Best answer by pratap

Hi,

 

 

Delete the tester in the "Transpose2013.fmwt" and use it.

 

 

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

1 reply

pratap
Contributor
Forum|alt.badge.img+11
  • Contributor
  • Best Answer
  • April 15, 2015
Hi,

 

 

Delete the tester in the "Transpose2013.fmwt" and use it.

 

 

Pratap

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