Skip to main content
Question

Having trouble with the Attribute Pivoter

  • November 27, 2018
  • 4 replies
  • 104 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!

 

4 replies

ebygomm
Influencer
Forum|alt.badge.img+33
  • Influencer
  • 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
  • Author
  • Contributor
  • November 29, 2018
ebygomm wrote:

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+20
  • Enthusiast
  • March 24, 2020
ebygomm wrote:

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!


daraghatsafe
Forum|alt.badge.img
philippeb wrote:

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.


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