Best answer by geomancer
View originalI 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
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
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.