Join 2 tables and bring aggregated value from right table

KNIME Analytics Platform
1

I have 2 tables. Column names are different but column values are same. But not all records are there in right table. I want to bring aggregated value from right table to left table where join conditions are matching. I can do group by on joining attributes before joining. But I am new to Knime and want to know if I can do this without group by, in joiner itself. Currently left table records are getting repeated when I am doing left outer join.

Thank you.

2

Hi @shubh and welcome to the forum.

If I’m reading you right, I think you will need to use a GroupBy first, prior to the Joiner. But maybe I’m missing something. To confirm, could you post a simple example of your input data, and what you’d like to see as the output?