Help with fields missing after 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
Hello,
I am very new to Alteryx, and I appreciate any thoughts you all may have. I am joining two sets of data using one field, ID number. The Left set of data has several additional fields of demographic data for each ID number, and the Right join has one additional field. I want to Join the two sets of data using ID number, so that I have one file that has the matching data from the left and right ID numbers with the additional fields from both data sets. Final data would include Matched ID Number, Address, City, State, and Start Date. I have selected all of my fields in the Join tool, and when I browse my output from the middle Join, aside from the ID Number, the left field record values are all Null, and only the records from the fields on the right have a value. Am I missing something, or doing something incorrectly? Thanks!
Left Data | Right Data | |
ID Number | ID Number | |
Address | Start Date | |
City | ||
State |
Middle Join output example:
Join Data Example | |||||
ID Number | Address | City | State | Right ID Number | Right Start Date |
4433 | [Null] | [Null] | [Null] | 4433 | 3/13/2020 |
3433 | [Null] | [Null] | [Null] | 3433 | 1/4/2020 |
2421 | [Null] | [Null] | [Null] | 2421 | 4/1/2020 |
7754 | [Null] | [Null] | [Null] | 7754 | 5/3/2019 |
5746 | [Null] | [Null] | [Null] | 5746 | 3/20/2019 |
Solved! Go to Solution.
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ahallock ,
could you provide the data files? The only option I can think of based on your description is, that fields have NULL values in source data.
Best,
Roland
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Roland, I think you are right. I just spot checked a few of the data points in my file and they are null there as well. Appreciate your help with this!