3 Replies Latest reply: May 10, 2016 4:21 AM by shweta gupta RSS

    Return same or similar records

    Didier Agonvonon

      Hi Guys,

       

      I am working on a Fraud detection project and need help with the following.

       

      I am trying to identify SAME or SIMILAR records from the same table. For example if on the employee table we have 2 different employee with the same account number , or the same home phone or same postal code. I typed a sample table below.

       

      I need some suggestions on the type of Qlik sense queries I could use for this purpose.

       

      Many Thanks

       

         

      Patient_IDMobileNM
      199784561
      277542168
      368542879
      411789562
      554789562
      633535565
      774145428
      894852630
      925893754
      1099784562
      1199784561