Appending data from a single row of Table 1 to all rows of Table 2?

I am struggling to append data from a single row of Table 1 to all rows of Table 2. Fields from Table 1 are to be added to the right of fields of Table 2.

Table 1 has 1 row and 5 fields
Table 2 has 10 rows and 9 fields

Resulting Table I am looking for will have 10 rows (same as Table 2) and 14 fields (fields from Table 1 + 2).

“Constant Value Column” node doesn’t work for me as I have Table 1 data coming from a source, which I don’t want to hardcode.

Hi @dhhillon and welcome to the KNIME forum

There is a node called “Cross joiner” which allows to do this “all to all rows” joining:

Hope this helps.

Best,

Ael

6 Likes

Thanks! Works perfectly.

2 Likes

@dhhillon glad to read it worked and thanks for having validated the solution :smiley:

Best

Ael

2 Likes

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