Skip to main content

Searched for possible solutions here, but nothing yet.

 

Have :
 

col0 col1 col2 col3 col4
Region A BU02851 BU02852 BU02853 BU02854
Region Value A 50 55 40 10
Region Value B 7 11 4 15
Region Value C 60 70 10 25

 

Need :

 

Region A Region Value C      
BU02851 60      
BU02852 70      
BU02853 10      
BU02854 25      

 

What steps do I need to take to get this done?

 

Thanks in Advance !

 

I always avoid transposing in FME because it gives me such a headache. I wanted to challenge myself and do it this time. See attached workspace (FME 2021). I don't like how it turned out and I hardly understand what I am doing myself.

The hardcoded AttributeCreators are bothering me the most. It feels like this must be doable dynamically with some proper Aggregator/AttributeExploder list-based-merge-wizardry. Welp, maybe next time.

 


Perhaps a similar solution to this thread:

The solution I proposed in that thread is similar to what @joepk has already suggested. And I will agree with @joepk, transposing in either direction is certainly headache inducing.


I proposed a similar solution to what @joepk has suggested in another thread, but using the AttributeExploder set to list, followed up with a ListExploder. I will link it here once the post is approved.


Thanks for the push @liamfez, it is done 😎

What a relief, hehe.
Hope this helps!


Thanks for the push @liamfez, it is done 😎

What a relief, hehe.
Hope this helps!

Thank you very much for your efforts.
It's more complicated than I thought. But luckily I can move on :)
Hopefully you don't have a headache anymore.


Very nice!

Just a small note: you can skip Tester_3 (Filter out Features where attr_name Begins With "fme_”) when you tell the AttributeExploder to ignore attributes starting with "fme_” using the ‘Ignore Attributes Containing’ option (see below).

The field contains a regular expression, so enter ^fme_ (which means attributes that start with “fme_”).

 


Very nice!

Just a small note: you can skip Tester_3 (Filter out Features where attr_name Begins With "fme_”) when you tell the AttributeExploder to ignore attributes starting with "fme_” using the ‘Ignore Attributes Containing’ option (see below).

The field contains a regular expression, so enter ^fme_ (which means attributes that start with “fme_”).

 

One more reason I hope I get to update to Form soon, still using 2021 for the time being and that does not appear to be an option. That is a small but very handy update to that transformer.


Reply