How to Include Right Side "L" in Join

Question

I'm joining current registrant data with previous registrant data.  I'm trying to get a count for the different statuses for current verses prior and compare.  The current data has a new status type that is not coming through when the data is joined.  I can see this spiked out if I click on the 'L' on the right side of the join tool.  How do I include this so that my total of current registrants is accurate?  I included a jpg of the desired output for the Registrant Reconciliation tab.

Registrant Data Workflow.zip

cjaneczko · Accepted Answer

You can add a Union Tool after the Join. Union the J and L of the output anchor and it will bring in the Left side with the Join.

nagakavyasri · Accepted Answer

Use Union with L and J of Join Tool:

caschecter1 · Accepted Answer

Add a select tool between the "L" output anchor and the union and rename the column "Current".

caschecter1 · Accepted Answer

Honestly, it looks fine and is working for me. My results below. One tip though. Because the order of the rows makes a difference to you (you want the totals on the bottom), make sure to check the "Set a specific output order" box in the Union tool. Without it checked, Alteryx can be random about how it puts the inputs to the union together.

Status Current Previous ChangeFuture Accruing 480 0 480RFP 3052 3003 49Inactive 163 158 5Active 2391 2205 186Duplicate Record 53 53 0Retired / PIF's 1603 1546 577742 6965 777