Skip to main content
Question

Transpose dynamically (like the Excel command)

  • September 19, 2018
  • 1 reply
  • 10 views

peteralstorp
Contributor
Forum|alt.badge.img

Hi. Me and my collegues have encountered this problem many times but we still haven't found an adequate solution. Please help! This is actually exactly what the Excel command Transpose does (when pasting copied data).

I want this data

to be transposed to this data

And if there a more ELEMENTS (after Zn) it should dynamically be included... We have looked at all the transpose posts here but we haven't found a good answer. ELEMENT, As, Ba and so on should be turned into attribute names for further use in the script.

Any help will be gratefully accepted.

Peter et al

1 reply

Forum|alt.badge.img+2

Hi @peteralstorp,

If the following article does not help you: https://knowledge.safe.com/articles/1315/advanced-manipulation-of-excel-tables-using-attrib.html

I think the best option would be to explore the Custom transformer AttributeTransposer available on the FME Hub: https://hub.safe.com/transformers/attributetransposer


Reply


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