Solved

Excel - transposed attributes not output in correct order.

Forum|Forum|10 years ago
April 14, 2015
1 reply
28 views

A

annette

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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.