In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Data Join Tool

Kristy_Hawkins
5 - Atom

I am using the join tool to merge two datasets into one. I see the data on the left when viewing the data, but when I view the data in the join view some data from the left is missing. Why is this and how do I fix it?

3 REPLIES 3
cjaneczko
13 - Pulsar

Can you provide a screenshot of what you mean? Which output anchor are you looking at (L,J,R)? The L only shows where there were no matches on the right, the J shows where there are matches on both, and the R show where there are no matches on the L.

Kristy_Hawkins
5 - Atom
 

I am not sure why the left is not joining the data on the right. I can match it based on the join feature 

 

cjaneczko
13 - Pulsar

Can you share the configuration window of the join? The workflow doesn't show where the issue is. Are the data types the same? Are there trailing white spaces on one side preventing the join?

Labels
Top Solution Authors