Skip to main content
Question

Multiple Attribute pivot

  • April 17, 2019
  • 1 reply
  • 56 views
mukhtarg
Contributor
Forum|alt.badge.img+4

Hello.

I have a file in which I have 3 columns a8_admin_name, cat and Subcat. Out of which i want to Cat column to be in Row and get its corresponding count for that particular a8_admin_name and then also get the same count for Subcat field for that particular a8_admin_name. Any help in this regard?

.

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.

1 reply

xiaomengatsafe
Safer
Forum|alt.badge.img+11

Hi @mukhtarg, thanks for your question. Just wondering if you've seen this article that works through an example of table pivoting. It seems quite similar to what you are trying to achieve.

https://knowledge.safe.com/articles/31702/pivot-table-using-fme.html

Hope it helps. Cheers,

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.