Skip to main content
Solved

How to sum up values separated by a comma?

grayson
Contributor
Forum|alt.badge.img+7

I'm an FME newbi. Feel like it's something very basic but couldn't come up with a solution on my own.

What I want to achieve is to get 80% of the value from column B to column A, but some of the features have multiple values separated by a comma, soo they come out as NULL.

I went through previously asked questions but couldn't find anything. Appreciate any help!

 

Zrzut ekranu 2023-05-02 172731

Best answer by dustin

Split the attribute at the comma with an AttributeSplitter, which will put the values into a list. Then use a ListSummer to add up the values from the list.image

View original
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

dustin
Influencer
Forum|alt.badge.img+36
  • dustinInfluencer
  • Influencer
  • Best Answer
  • May 2, 2023

Split the attribute at the comma with an AttributeSplitter, which will put the values into a list. Then use a ListSummer to add up the values from the list.image

grayson
Contributor
Forum|alt.badge.img+7
  • graysonContributor
  • Author
  • Contributor
  • May 3, 2023

well, it helped! Thanks a lot!

 

I tried to use Attribute splitter before, when working on something different, but without ListSummer. It didn't make any sense back then. Thanks again!

Community Stats

32,971
Posts
124,965
Replies
41,870
Members
Terms & ConditionsAccessibility 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.