Skip to main content
Question

Having trouble with the Attribute Pivoter

  • November 27, 2018
  • 4 replies
  • 164 views
stefanh
Contributor
Forum|alt.badge.img+8

I have the following table.

labelareacodecountA100114A10023A10032A10188A10291B100164B10022B10041B101268B102121C100137C10024C10042C101493C10217

 

I want to pivot the table. So I get the following result.

RijlabelsABC1018826849310291121171001146437100232410032

 

 

1004

 

12

 

I tried the AttributePivoter (and also the AttributeTransposer) but I can't get this to work. I don't understand what I am doing wrong.

 

Hope someone can help me with this issue!

Thanks!

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • November 27, 2018

I normally pivot data by using the Attribute Values to create new attributes

Pivot_attributes.fmwt

 

stefanh
Contributor
Forum|alt.badge.img+8
  • stefanhContributor
  • Author
  • Contributor
  • 38 replies
  • November 29, 2018

I normally pivot data by using the Attribute Values to create new attributes

Pivot_attributes.fmwt

 

Thanks! This works.

philippeb
Enthusiast
Forum|alt.badge.img+22
  • philippebEnthusiast
  • Enthusiast
  • 329 replies
  • March 24, 2020

I normally pivot data by using the Attribute Values to create new attributes

Pivot_attributes.fmwt

 

Would that be possible to put once again online the fmwt? Thanks!

FME Lover
daraghatsafe
Forum|alt.badge.img
  • daraghatsafe
  • 135 replies
  • March 27, 2020

Would that be possible to put once again online the fmwt? Thanks!

Hi @philippeb

I don't have the exact workspace that you are looking for but here is a post that may help with your question.

https://knowledge.safe.com/articles/31702/pivot-table-using-fme.html

Also as this post is over 3 years old it may be best to post a new question if you are still stuck.

Community Stats

32,076
Posts
121,797
Replies
39,707
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.