Duplicates Issue

mmaziere

This is my first post in the help forums. I am new to Alteryx and have a workflow containing duplicates that should not be duplicates. For example, in the following duplicates output from the unique tool, I have a record "Job ID2" (1000123243) that is not duplicated, but the "Route" value is:

How can I get this record to show up in the Unique output instead?

MichaelCordoba

What the unique tool is doing is removing whatever duplicate record it finds based on Ship-to column regardless of the other column values.

You will need to select one or more extra columns ( i.e Job ID2 and ship-to)