I’m quite certain that this is a limitation of KNIME, but if there’s anything I’ve learned, it’s that people know the tool better than me. I’m working with a table (pictured below) that has an identifier column and 4 columns of numbers. The desired result is for the “Totals” column to contain the summed amount of all columns based on identifier. As a result, the totals column would have 6 rows. I have used a groupby node to produce the second table that demonstrates what I’m aiming for. I attempted to append the second table but received an error message “Tables can’t be joined, non matching row counts: 10 vs. 6.” This is what I was expecting and is why I think this might be unfeasible. Just curious if there is a solution or a clever work-around. Thanks in advance for your help.
Hey @ArgenEX, I went ahead and did that, but there’s still duplicate values of the total. It is not significant, but for the purpose of a cleaner output, is it possible to reduce the rows from 10 to 6, combining like rows into one?
What should happen with the information in the rows then? What you could do is the groupBy node again, whereby column 1 is the group, column 2,3,4,5,6 are aggregated by Concatenate, and column 6 by Sum.
