Join Tool Issue
- 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
Hi everyone! I am running into an issue when using a join tool. I am joining two data sets based on email (I have taken the first part of each email from both data sets before the '@' symbol, because some of the email extensions do not match between systems. I am seeing some user's email duplicated in the join output but they also have different names in the output. Here is one example:
** Blocking out sensitive information **
Looking at the formula output before the join output to the left (searched peeples):
(Image 1)
Looking at the formula output before the join output to the right (searched peeples):
(Image 2)
They have the same name and email in both sources, but here is the output from the join step:
(Image 3)
As you can see, there is a new name created and new org, department, and manager data mapped to the new record. I am not sure where the name “kaylyn peeples” is being created as there is no one with this name or even the first name from either of the data sources. This is happening for a handful of users. Can someone please assist with this and let me know what could be happening here?
Solved! Go to Solution.
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For the data going into the Left and Right Join input anchors: add a Browse tool
you mentioned
I am not sure where the name “kaylyn peeples” is being created as there is no one with this name or even the first name from either of the data sources
You may not be seeing all of the data, without a Browse tool. No new data is being created. kaylyn is in one of those input sources, somewhere.
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@taliatest
It is very hard to tell what goes wrong here as you did not share enough data. As @ChrisTX this name will be part of the data unless you are creating it in one of your formula tools, as we do not know what is going on in your WF it is very hard to tell what goes wrong.
If you will share more data a better answer can be given.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you both! I did not realize that I was not viewing the whole data set and added a browse tool as suggested. I see where the second user is coming in now. Thanks!