I’ve got two tables with no relationship and I want one of the columns from the second table to be added to every row of the first. A full outer join would accomplish this, but the joiner node is requiring a field to join them on. The row ID doesn’t work because it results in only the first row appending the value from the second. So how is a full join accomplished with this node?
Never mind. I’ve discovered the Constant Value Column node which will generate a value that can be added to both tables and joined on producing the same output as a full outer join.
2 Likes
Hi @kevinnay
Glad to see you find a solutionn. An other option is the Cross Joiner (no extra nodes needed).
gr. Hans
2 Likes
I like your way better. Cleaner than what I had. But strangely, the output of that is resulting in an Oracle error ORA-00917 missing comma and for the life of me I don’t know how you can troubleshoot that when the node is handling the query. If there was a stray column in the data I would think the data frame would have parsed it incorrectly, but I see no visible signs of a problem with the output of the cross joiner.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.