Hello
I have a table with 'duplicates' (i.e. duplicate records) per each Col1 value and I want to check which Cols are causing this 'duplication'.
E.g.
Product1, Price1, Location1,Region1
Product1, Price2, Location1,Region1
Product2, Price1, Location1,Region2
Product2, Price1, Location2,Region2
...
In the above, both the Price and Location are causing 'duplication' but not the Region.
Is there a neat way to identify these Cols?
Thanks!