I want to join two tables, but in a very specific way. The first table should remain the same, but from the second table, I want to compute the sums for each group of thousand. I'm new to knime, so a detailed solution would be great.
The two Tables look like this (the right collumn doesn't matter):
Class Value
1000 25
2000 35
3000 40
and
Class Value
1000 30
1100 50
2000 10
2100 20
2200 30
3000 50
3200 40
The result should look like this:
class value 1 value 2(sum)
1000 25 80
2000 35 60
3000 40 90
thanks a lot!