Skip to main content
  • EN

Hi All,

I’m not able to transpose rows to column and complete a count in the end of the workflow, I have followed the technical article but couldn’t make it to work:

https://support.safe.com/hc/en-us/articles/25407761369741-Transpose-a-Table-Using-FME

Also below an screenshot of the requested output which a excel pivot table:

 

Attached a sample of the raw table that needs to be transposed (or pivoted!)

Can I achieve this with the AttributePivoter?

Thanks

 

Hi ​@galigis, recently I answered a comparable question, check out this link. I think it is what you are looking for :)

Rows to Columns | Community

Thanks ​@lambertus - I have tried the hub transformer but unfortunately didn’t work for me ,

Alternatively, I was able to achieve the requested pivot table by adding the following transformers:

 

  • StatisticsCalculator
  • AttributeCreator
  • AttributeExposer
  • AttributeKeeper
  • Aggregator

Attached the template for reference, below an example of the final output:

I hope this is helpful to anyone who needs it

Thanks :)

Hi ​@galigis, happy to hear that you created a nice solution yourself! 😃

I am still interested what went wrong for my own workspace, maybe a difference in FME version plays a role..

Community Stats

31,897
Posts
121,119
Replies
39,512
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.