multi join

hi everyone.
i have 2 table =>.table 1 and table 2 .
in table 2 i have 10 column that i should in turn join every single column to column B from table 1 .
what is the best way to do this .
please guide me .

Do you want to join or concatenate?

i wanna in turn join every column of table A with one column in table2

i’m not sure if this is exactly what you need and this is what I came up so far.
KNIME_cols_ join_MM.knwf (124.8 KB)

Hi @alrz,

I don’t know if I’ve correctly understood your problem, but here’s a possible solution.

Could you provide a small example (even an Excel screenshot, just to grasp the logic)?
It would much easier to help :slight_smile:

Have a nice day,
Raffaello Barri

1 Like