Is it possible to continue a refresh process if duplicate entry is found on one side of relationship

[tvaishnav]

I have a situation where my refresh fails because users put bad data.

I would prefer if refresh continues and drops all duplicate entries after the first entry is found. It would be nice if I get a warning via some email notification.

Is this possible? One bad data entry kills the entire report and makes it unusable. 

[Greg_Deckler]

@tvaishnav Perhaps just add a remove duplicates step to your query?

[tvaishnav]

Thanks for pointing that out. But that will remove the data and not really inform anyone about the problem.