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.