Question

Multiple Attribute pivot

  • 17 April 2019
  • 1 reply
  • 2 views

Badge +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?

.


1 reply

Badge +2

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,

Reply