Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Join Tool Issue

taliatest
6 - Meteoroid

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?

3 REPLIES 3
ChrisTX
16 - Nebula
16 - Nebula

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

OTrieger
12 - Quasar

@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.

taliatest
6 - Meteoroid

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!

Labels
Top Solution Authors