Load data without duplicate records - multiple columns

[Anonymous]

Hi,

i want to load tables, but without duplicate records. The value in column Product + Customer must be unique. It should be load always the record with the highes SaleNumber.

How can i do it?

Example - the red marked records shouldn´t load:

Regards,

sam

[Anonymous]

Perfect, thanks 🙂