Transpose Colums/Rows

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:

• Transpose excel data by feature ID

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.

joepk wrote:

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_”).

geomancer wrote:

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.