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 

binuacs
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