Workflow JOIN TOOL Duplication Error

Question

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.

Variance Report.xlsx

danilang · Answer

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

apathetichell · Answer

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...)

T_Willins · Answer

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.yxmd