Join by Record ID is dropping rows

[Travis_Ratliff]

Hello All,

I have a workflow similar to this problem: Solved: Merging two data outputs with union tool, how to r... - Alteryx Community. 

My workflow uses record ID on two tables and then joins them based on the record ID. However, Table1 has 8 rows and Table2 has 6 rows so rows 7 & 8 on Table1 are being dropped from the Join tool because they do not have a matching record ID to join them with.

Any help with this is appreciated.

What I want my end result to be is

Table1 Header  |  Table 2 Header

Row 1               |  Row 1

Row 2               |  Row 2

Row 3               |  Row 3

Row 4               |  Row 4

Row 5               |  Row 5

Row 6               |  Row 6

Row 7               |  Blank

Row 8               |  Blank

[DataNath · Accepted solution]

Hey @Travis_Ratliff - to get around this, you basically want to conduct the equivalent of a Left Join which is done like this in Alteryx, by re-unioning the results that don't find a match:

Note: If your tables are the other way round, you'll need to union the R and J anchors, rather than L and J like my example.