Sum column by similar names

Good day!
please help me with such topic -
I have a table, that looks like this:

Brand Number
Z 74
X 12
C 41
ZZ 24
XY 23
CB 52

Can I some-how sum rows with “Z” and “ZZ”. As a result a need it to look like this:

Brand Number
ZZZ 98
X 12
C 41
XY 23
CB 52

Thanks!

You can just change “Z” and “ZZ” to “ZZZ” using the rule engine (or expression node of your choice), then do a GroupBy node and sum your “Number” column while grouping by your “Brand” column.

Unless you need it to be dynamic. If so, then let us know if it would always be based off the 1st character in the Brand string column.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.