Solved

How to sum up values separated by a comma?


Badge

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

icon

Best answer by dustin 2 May 2023, 18:25

View original

2 replies

Userlevel 3
Badge +26

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

Badge

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!

Reply