Join Logic

[Alteryxuserhere]

Hi There

I would like to check which of the people in File A has a match in File B either based on ID, Email, Name or Mobile, hence the 4 different Joins. But seems to not work. Can some advise what am I missing? thanks!
 

[niklas_greilinger]

Hi @Alteryxuserhere ,

I think the issue appears in your third join (on Mobile) Here you did not connect the L anchor (with the remaining records) but the R anchor (with already joined records) to the next and last join.
Please try and connect the L anchor in all cases here.
Let me know if this helps.

[aatalai]

@Alteryxuserhere I would suggest using a data cleanese too after each data input to ensure that there aren't any formatting inconstancies 

[Qiu]

@Alteryxuserhere 
I would suggest that we can transpose the data then compare the column and the value.
We can do more in case you want a different presentation of matching result.