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
Best answer by geomancer
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)
Note: ListKeyValuePairExtractor uses Python under the hood.
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.
+58- Evangelist
- 932 replies
- Best Answer
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)
Note: ListKeyValuePairExtractor uses Python under the hood.
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)
Note: ListKeyValuePairExtractor uses Python under the hood.
Thanks geomancer! It works like a charm.