# Joiner (Full Outer) Issue

**URL:** <https://forum.knime.com/t/joiner-full-outer-issue/84279>\
**Category:** KNIME Analytics Platform\
**Created:** [November 5, 2024, 7:31pm UTC](https://forum.knime.com/t/joiner-full-outer-issue/84279 "2024-11-05T19:31:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kevinnay](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/k/d6d6ee/32.png) [@kevinnay](https://forum.knime.com/u/kevinnay)\
**Post date:** [November 5, 2024, 7:31pm UTC](https://forum.knime.com/t/joiner-full-outer-issue/84279/1 "2024-11-05T19:31:23Z")

</div>

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?

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/5/35857dc96dffa954783095499fc5333f97bc27ed.png)

---

<div class="post-metadata">

**Author:** ![kevinnay](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/k/d6d6ee/32.png) [@kevinnay](https://forum.knime.com/u/kevinnay)\
**Post date:** [November 5, 2024, 7:43pm UTC](https://forum.knime.com/t/joiner-full-outer-issue/84279/2 "2024-11-05T19:43:57Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![HansS](https://forum-cdn.knime.com/user_avatar/forum.knime.com/hanss/32/6979_2.png) [@HansS](https://forum.knime.com/u/HansS)\
**Post date:** [November 5, 2024, 7:50pm UTC](https://forum.knime.com/t/joiner-full-outer-issue/84279/3 "2024-11-05T19:50:12Z")

</div>

Hi @kevinnay

Glad to see you find a solutionn. An other option is the Cross Joiner (no extra nodes needed).

> **[Cross Joiner](https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.crossjoin.CrossJoinerNodeFactory)**
>
> Performs a cross join of two tables. Each row of the top table is joined with each row of the bottom table. Note, this is an extremely expensive operation as t…

gr. Hans

---

<div class="post-metadata">

**Author:** ![kevinnay](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/k/d6d6ee/32.png) [@kevinnay](https://forum.knime.com/u/kevinnay)\
**Post date:** [November 5, 2024, 7:55pm UTC](https://forum.knime.com/t/joiner-full-outer-issue/84279/4 "2024-11-05T19:55:25Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [November 12, 2024, 7:56pm UTC](https://forum.knime.com/t/joiner-full-outer-issue/84279/5 "2024-11-12T19:56:09Z")

</div>

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