Skip to main content
Solved

How to sum up values separated by a comma?

  • May 2, 2023
  • 2 replies
  • 74 views

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

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+31
  • Influencer
  • 629 replies
  • 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
  • Author
  • Contributor
  • 3 replies
  • 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!