+5
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
Best answer by caracadrian
View original
+20
@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.
+5
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?
+20
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.
+5
But 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?
+5
It works fine. Thank you.
Is there any transformer that can perform the pivot in one go?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
