Skip to main content
  • EN

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!

 

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

Pivot_attributes.fmwt

 

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

Pivot_attributes.fmwt

 

Thanks! This works.

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!

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


Community Stats

30,176
Posts
114,544
Replies
37,837
Members
Terms & ConditionsCookie settings
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.