Forum Discussion

sjrrkb123's avatar
sjrrkb123
Helper III
5 years ago
Solved

Finding Duplicates in a Table

So I have worked with finding duplicates a lot in the past but I am struggling in the current situation.  What I am trying to do is to find any professional keys that exist in both the "Owner" & "...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    sjrrkb123 , Create a new column like

     

    new column =
    var _1 = countx(filter(Table, [Project Key] = earlier([Project Key]) && [Professional Key] && earlier([Professional Key])),[Project Key])
    return
    if(_1 >1, 1,0)

amitchandak's avatar
amitchandak
Super User
5 years ago

sjrrkb123 , Create a new column like

 

new column =
var _1 = countx(filter(Table, [Project Key] = earlier([Project Key]) && [Professional Key] && earlier([Professional Key])),[Project Key])
return
if(_1 >1, 1,0)

  • sjrrkb123's avatar
    sjrrkb123
    Helper III
    5 years ago

    amitchandak  it worked Great! I had to tweak it with the following but I appreciate the help greatly.

    new column =
    var _1 = countx(filter(Table, [Project Key] = earlier([Project Key]) && [Professional Key] && earlier([Professional Key]) && RoleName IN {"Sponsor", "Owner"}),[Project Key])
    return
    if(_1 >1, 1,0)

    as I only care about duplicates in those two roles.