Full outer join in join node and keep original row ID
I want to merge different columns in different tables with same set of row ID, however some rows may be missing in some tables, for example:
table 1:
| rowID | color |
| 0 | yellow |
| 2 | red |
| 3 | red |table 2:
| rowID | fruit |
| 0 | banana |
| 1 | apple |
| 2 | apple |I am expecting following table:
| rowID | color | fruit |
| 0 | yellow | banana |
| 1 | | apple |
| 2 | red | apple |
| 3 | red | |I tried full outer join and keep row keys which is denied by joiner node as “Cannot reuse input row keys for output”. Any workaround?