ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. 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.

Duplicates after join tool

Sifiso
8 - Asteroid

Hi all

 

I have grouped and summed the data using the summarise tool and then joined using the joined tool. the problem now is that the data is duplicated. I tried to remove the duplicates using the unique tool but it did not work.

 

any ideas?

2 REPLIES 2
BRRLL99
11 - Bolide

for J anchor of joint tool use unique tool , this will remove duplicates 

binu_acs
21 - Polaris

@Sifiso The join tool generating the duplicate rows because you have duplicates records in the summarize tool output, try to remove duplicate records from the summarise tool

Labels
Top Solution Authors