• Home
  • Forums
  • FME Form
  • Transformers
  • I would like to transpose the attached data structure. I have tried using the attribute transposer without luck. The attached excel has the input structure and the desired output. Many Thanks, Andrew
Solved

I would like to transpose the attached data structure. I have tried using the attribute transposer without luck. The attached excel has the input structure and the desired output. Many Thanks, Andrew

  • 2 August 2021
  • 2 replies
  • 3 views
A
I would like to transpose the attached data structure. I have tried using the attribute transposer without luck. The attached excel has the input structure and the desired output. Many Thanks, Andrew
icon

Best answer by geomancer 2 August 2021, 11:43

View original
1 Attachment

2 replies

geomancer
Rank
Userlevel 4
Badge +36

Create a list with ListBuilder (Group By: ID), and feed it to the custom transformer ListKeyValuePairExtractor from FME Hub. Finally expose the new attributes with the AttributeExposer. See the attached workspace (FME 2020.0)

fmetransposeNote: ListKeyValuePairExtractor uses Python under the hood.

A

Create a list with ListBuilder (Group By: ID), and feed it to the custom transformer ListKeyValuePairExtractor from FME Hub. Finally expose the new attributes with the AttributeExposer. See the attached workspace (FME 2020.0)

fmetransposeNote: ListKeyValuePairExtractor uses Python under the hood.

Thanks geomancer! It works like a charm.

Reply


Community Stats

28,706
Posts
109,467
Replies
36,549
Members
Terms & ConditionsCookie 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.