Alerts on Output Dataset Fail with False Claim of Duplication


When attempting to add an alert to the output dataset of one of our dataflows we receive the below error message:




We have added a Remove Duplicates step to the dataflow  on the `Case Number` column just before the output dataset, however this message is still being received. We even compared the Count to the Distinct Count of the `Case Number` column and the numbers are equal.


Any ideas as to what the issue is here?


  • MichelleH

    @MosesWynn Are you checking for duplicates in any other other columns besides Case Number in your Remove Duplicates tile? It's possible that you could have multiple rows with the same Case Number if you are removing duplicates based on multiple columns.