problem with a query

KNIME Analytics Platform
1

Hi,

I have a table like this:

x - y - z1 - z2

a - a - 0 - 1

a - a - 1 - 0

b - a - 0 - 1

and i want a table like this:

x - y - z1 - z2

a - a - 1 - 1

b - a - 0 - 1

How can do this in knime?

Thanks

 

2

Ar eyou looking for something like a groupby?  I think in this case if you group by x and y, and aggregate the sum of z1 and z2, you will get the transformation you are looking for. 

Regards,

Aaron