[SOLVED] Join with summed rows

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!

You could calculate the thousand part for the class of the second table: with node "math Formula" you could do something like "($Class$ - mod($Class$, 1000))" ; then with a groupBy node you group on this thousand part and calculate the sum. 

It worked, thanks!