Forum Discussion

carterth's avatar
carterth
Regular Visitor
3 years ago

Find in which column primary key duplicates

Hi Hive mind,

 

I'm pulling a report and found against which materials the primary 4 columns duplicate. I've merged these into one, so there are now 2 clear rows for each of the primary 4. I now need to be able to find where in the secondary columns (6 in total) the duplication is. This is easy to see visually using conditional formatting but as the data set will get quite large, I'd need to be able to extract answers quickly. 

 

Eg. In which rows does Status Duplicate?

 

 

Need Help

1 Reply

  • adudani's avatar
    adudani
    Memorable Member
    3 years ago

    hi carterth ,

    refer to the video below:

    (24) Find Duplicate Values in Dimension Tables - YouTube

     

    I think if you want to check for the merged primary key for a duplicated status: 
    You could either add a condition to the formula used above, by using a variable checking the product status.

     

    Alernatvely, using a column concatenating Merged Primary Key and Status and Apply the formula in the video. So, if that has a duplicate, the concatenated column would end in Y and have a count of =>2.