Question

Having trouble with the Attribute Pivoter

  • 27 November 2018
  • 4 replies
  • 19 views

Badge +2

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

Badge +10

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

Pivot_attributes.fmwt

 

Badge +2

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

Pivot_attributes.fmwt

 

Thanks! This works.

Badge +2

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!

Badge

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.

Reply