FME Desktop 2022.1 Build 22618: How to perform the “AttributePivotor”?
I couldn’t figure out how to apply the “AttributePivotor” in order to derive the “R” table from “Q” table as per the screenshot.
The data is attached
Solved
FME Desktop 2022.1 Build 22618: How to perform the “AttributePivotor”?
+5Best answer by caracadrian
@jamal the data you attached is different from your example. I was able to recreate your Q table via Clipper and AttributeManager...
You set AttributePivoter with Group Rows By Name, Group Columns By Area_ABC_English (Type) and Attribute To Analyze: Percent. The rest doesn't really matter.
After that you expose Area A, Area B and Area C attributes via AttibuteExposer or AttributeManager.
I have attached a template workspace with the desired settings.
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.
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.
+23- Contributor
- 571 replies
- Best Answer
@jamal the data you attached is different from your example. I was able to recreate your Q table via Clipper and AttributeManager...
You set AttributePivoter with Group Rows By Name, Group Columns By Area_ABC_English (Type) and Attribute To Analyze: Percent. The rest doesn't really matter.
After that you expose Area A, Area B and Area C attributes via AttibuteExposer or AttributeManager.
I have attached a template workspace with the desired settings.
+5Thank you caracadrian for the help.
Sorry for attaching the wrong data. I managed to re-attach the correct one (S.gdb)
The “AttributePivotor” is performed (as per the screenshot) but the output appears not to be as expected.
What could be the issue here?
+23- Contributor
- 571 replies
Thank you caracadrian for the help.
Sorry for attaching the wrong data. I managed to re-attach the correct one (S.gdb)
The “AttributePivotor” is performed (as per the screenshot) but the output appears not to be as expected.
What could be the issue here?
You need to expose the newly created attributes via the AttributeExposer transformer.
+5But why the output of “AttributePivotor” is just nothing? I’m expecting that this transformer will be doing the transpose in one go.
What is the benefit of using the AttributeExposer transformer if the output of the “AttributePivotor” is just nothing?
+5It works fine. Thank you.
Is there any transformer that can perform the pivot in one go?
