Joins two tables based on one reference column, introducing missing values where no corresponding entry is found.
Duplicate column names will have "_1" appended automatically.
- Example 1 (how it is envisioned to be used):
Also, row (7,g) from table 1 is linked with rows (7,g) and (7,h) from table 2.
In contrast, rows (1,a) from table 1 is only joined with row (1,a) from table 2 because the following row (1,b);(1,b) can be joined directly.
Input1 Input2 Result 1 a 1 a 1 a 1 a 1 b 1 b 1 b 1 b 2 c 3 c 2 c ? ? 3 d 4 d 3 d 3 c 5 e 5 e ? ? 4 d 6 f 6 f 5 e 5 e 7 g 7 g 6 f 6 f 7 h 7 g 7 g 7 g 7 h
- Example 2 what happens if list are not sorted or inversely sorted:
Input1 Input2 Result 7 g 1 a ? ? 1 a 6 f 1 b ? ? 1 b 5 e 3 c ? ? 3 c 3 d 4 d ? ? 4 d 2 c 5 e ? ? 5 e 1 a 6 f ? ? 6 f 1 b 7 g 7 g 7 g 7 h 7 g 7 h 6 f ? ? 5 e ? ? 3 d ? ? 2 c ? ? 1 a ? ? 1 b ? ?