Duplicate rows - Ignore

Question

Hi,

I have 6 columns. Lets consider the column names as A,B,C,D,E,F. If all the first four column (A,B,C,D) values are same, then we consider it as duplicates. We need to load the data only if atleast any of the first four column values does not have the same value. Is there any way

For example, the below is consider as duplicate and I want to avoid that

Thanks

Answer 1

Hi @Anonymous , you can create composite key with this 4 i.e., A,B,C,D columns. Thanks!