Skip to main content

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..


Reply