We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Workflow JOIN TOOL Duplication Error

jalizmaldonado
8 - Asteroid

Hi, I created a variance report workflow but the output seems to be creating multiple duplications that I can't figure out how to solve or remove. The duplication error occurs when I use the join tool and match the data to the file # and name columns. Attached you'll find a file with the "previous and current input" data (Previous Input Tab & Current Input Tab) before the join tool. The tab labelled as "With Details" is the output at the join tool. I tried using the union tool but that created a different headache. Not really sure what to do at the moment. 

3 REPLIES 3
T_Willins
14 - Magnetar
14 - Magnetar

Hi @jalizmaldonado,

 

I'm not able to recreate your error using the Join tool.  Attached is the workflow that I created to join the data together.  Please advise if there is something different that should be done in the workflow.

 

join tool error.png

 

apathetichell
20 - Arcturus

If you are joining multiple entries with the same file# and name columns each entry will need to be joined which means that you'll get extra versions if you do not have a unique name/file# for each record. Looking at your data - you probably need to be joining on more columns - ( try to join on memo code too and see how that works...)

danilang
19 - Altair
19 - Altair

Hi @jalizmaldonado 

 

The output you provided looks like you've joined on Name only.  That's why the the left input is duplicated for each row on the right.  Check the configuration of your join tool.

 

Dan 

Labels
Top Solution Authors