How to Include Right Side "L" in Join
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use Union with L and J of Join Tool:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I added the union and see this status coming in but it's not pulling the count to Current. How can I fix this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Add a select tool between the "L" output anchor and the union and rename the column "Current".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
