Skip to main content
Solved

Hi, Can please someone help me with calculating percentage change (X2-X1)/X1*100 for column Value when grouped by column Category. More specifically, how can get table 2 from table1.

  • September 12, 2023
  • 2 replies
  • 73 views

Forum|alt.badge.img

In table 2, the percentage change was calculated separately for each category of A, B, and C. I'm using FME2022.

 

Table 1

table1Table 2

table2

Best answer by ebygomm

You should be able to do this with adjacent attribute mapping in an AttributeCreator

 

image

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.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • Best Answer
  • September 12, 2023

You should be able to do this with adjacent attribute mapping in an AttributeCreator

 

image


Forum|alt.badge.img
  • Author
  • September 12, 2023

@ebygomm thank you so much. This is a great answer!