join two tables

Hello !
I need help.
Maybe someone will know how to combine these two tables.
knim

Hello @spastor

First of all welcome to the world of KNIME.

The Joiner node Join example workflow – KNIME Hub might be what you are looking for

Hi @spastor and welcome to the Knime Community.

You can’t have duplicate column headers, so you can’t get X and Y twice.

@knimediger , the Joiner node will not produce the results that @spastor is looking for. With the Joiner node, you can get the columns ID, A1, X, Y. Note, this has nothing to do with the duplicate headers that I raised.

Okay, you are right,
Probably I will have to use a loop
Name column can be different.
For example:
knime3

Hello @spastor,

you need to use GroupBy node based on ID on your second table with aggregation method List for each column. Then you can use above mention joiner node to bring List columns to your first table. Close it with couple of Split Collection Column nodes.

Welcome to KNIME Community!

Br,
Ivan

3 Likes