Remove Duplicates

[risabhroy_03]

Hi,

I have concatenated various tables and I can see some duplicated records. Can anyone help me with how to remove those?

I want Company Code, Customer, Customer Part and Internal Part to be unique

[abhijitnalekar]

Hi @risabhroy_03 ,

duplication of the data after joining two table depends on the relationship between the two tables. if both tables join with many to many or one to many join it will duplicate the records.

IS it possible to share the relationship diagram of the tables?

[vinieme12]

can you clarify which rows need to be removed? and based on what criteria

[risabhroy_03]

My Company Code, Customer, Customer Part, and Internal Part should be unique in every record.

No two lines of record should have all the above same, at least one column should have a different value.