Skip to main content
Solved

Workflow for transposing attributes into rows


smishsmosh
Participant
Forum|alt.badge.img+1

Hello all,

 

Complete FME newbie here

I need to transform the data compiled by a different department as an excel spreadsheet to look like this:

From

 

Initial structure

 

To

 

Final structure


Basically the idea is to pair each of the projects with each of the areas in order to then join the final table to a different spatial table on the ‘AREA’ attribute, ideally without manual input into transformers. The project attribute will have new entries added to it, with corresponding counts, the areas will remain the same.

Thank you.

Best answer by crutledge

Hi ​@smishsmosh (love the name :D)

The AttributeExploder is great in this case:
Transposing Data for Business Intelligence – FME Support Center

Also here is a great article on all things transposing:
Transpose a Table Using FME – FME Support Center

Hope that helps!

View original
Did this help you find an answer to your question?

2 replies

crutledge
Enthusiast
Forum|alt.badge.img+32
  • Enthusiast
  • Best Answer
  • April 28, 2025

Hi ​@smishsmosh (love the name :D)

The AttributeExploder is great in this case:
Transposing Data for Business Intelligence – FME Support Center

Also here is a great article on all things transposing:
Transpose a Table Using FME – FME Support Center

Hope that helps!


smishsmosh
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • April 28, 2025

That’s great, thank you so much


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings