Basic Merging of 2 Tables

[Yush]

Hello,

I’m new to KNIME.

I want to merge 2 tables in a particular way, but I can’t figure out the correct nodes to use.

Table 1: (1 column, 2 rows)

0
1

Table 2: (1 column, 2 rows)

A
B

I want the output to look like:

Output Table: (2 columns, 4 rows)

A 0
A 1
B 0
B 1

Thanks,
Yush

[adaptagis]

hi.Yush… that looks honestly a bit odd to me but I suggest to:

…first make shure that the two tables are in the matching order
then join the two tableas using RowID
finally connect the joined table on both inputs of the concatenate node to doublicate the
table…

[Yush]

Hi adaptagis,

Thanks for your response, and my apologies as the output table showed incorrect info.
I’ve edited this now in my first post… so I’m not sure if your solution still stands.

If I were to add another row to table which said ‘C’ then I would want the output table to look like:

(2, columns, 6 rows)

A 0
A 1
B 0
B 1
C 0
C 1

Kind regards,
Yush

[ipazin]

HI!

That first output was by no means basic join Try Cross joiner node

Cross Joiner — NodePit

Br,
Ivan

[Yush]

This worked perfectly, thanks to you both.

Kind regards,
Yush