Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

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

after the join tool, some lines(records) are duplicated!!

ueni
6 - Meteoroid

left data set has 96 records, right data set has 178 records - used join tool to join by specific fields and the final output came out with some duplicate lines, was expecting 96 records from left data set with new additional fields as result of join but duplicate records have been generated! what it could be .. been using join on other occasions and it worked well but no idea what's the gap here? can you please help

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@ueni 
You can check the Left anchor of the Join too, what is the data stream that could not be matched.
If you can upload some some sample data, we can take a look.

ueni
6 - Meteoroid

worked with Tony, he advised to use 'Unique' tool before the join to get rid of duplicate rows and it worked!

Labels
Top Solution Authors