KNIME Joiner and creating new rows

Hello everyone,

I want to join two tables by using two identification variables (A&B). B has several characteristics in table 2 but has only one characteristic in table 1. After joinig the two tables I want to add all the other characteristics from B from table 2 into table one (so adding rows).

I would appreciate every suggestions from you. Thanks in advance!

Welcome to KNIME forum.
What you need sounds as a right outer join of tables A and B. Please let us know if it works for you.

1 Like

Hi there @mari_wtr,

welcome to KNIME Community!

From my experience example of input and output data usually helps others understand your requirement/task very well and thus help/suggestion comes much sooner :wink:

Br,
Ivan

1 Like

Hi there, tank you so much for your quick respond!

Sadly the right outer join did not work for me. But I came to a solution by using a group loop. :slight_smile:

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