The equivalent tool to “pivot table” of ArcGIS in FME,
I couldn’t figure out which tool is equivalent to “pivot table” of ArcGIS in FME. I have a layer and I want to rearrange the attribute table in a specific way
The following picture shows my need
when i use the pivot table tool the table is look like this
Thanks in advance
Best
Change the attribute name "Percentage" to the VALUE of "ABC"; aggregate features grouping by "Name"; expose the new attribute names.
Alternatively, the AttributeCreator can be used instead of the BulkAttributeRenamer.
Finally remove unnecessary attributes with the AttributeRemover.
Takashi
but is there any method to let the FME create new fields with new names based on the entries of a colum in attribute table
to be like this
best
just an untested idea, but is it possible that the AttributePivoter could be helpful here?
David
@takashi thanks for the answer! I have the same problem.
How can I keep the selected attributes which I have got after AttributePivoter?
I don't know the names in advance it's a dynamic list of attributes.
+15Is there an alternative to AttributePivoter? I have a table that I needed to transpose and after the pivot it has 500+ attributes to expose. Occasionally, the schema of the table has to be changed and the attributes I need to expose are now changed, So now I have to import the updates into my work bench.
+11Is there an alternative to AttributePivoter? I have a table that I needed to transpose and after the pivot it has 500+ attributes to expose. Occasionally, the schema of the table has to be changed and the attributes I need to expose are now changed, So now I have to import the updates into my work bench.
Hi @salvaleonrp,
This Q&A thread appears to be from quite a few years ago, would you be open to posting a new question for better visibility? It's easy to overlook new comments on an old post and at a glance this one looks like it's already solved.
In the meantime have you already taken a look at our Pivot Tables and FME article and Manipulation of Tabular Data? Both contain examples of the transformer that may hopefully be helpful. Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
