Join 2 tables and bring aggregated value from right table

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.

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?

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.