Hi Dave,

Is it a good way to use Unique Id field in Key Column and actual field in Name column to avoid duplicate issue.

For example, I'm facing issue in LastName field (both Case and Blank values) in Employee.

Option 1:

Use Emp_Id as Key Column and LastName in Name Column.

Option 2:

Expand Key Column properties, and set Trimming, NullProcessing, and Collation to solve the problem.

Plz let me know your thoughts.

Thanks,

Suresh