Return same or similar records

[didierodayo]

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_ID	MobileNM
1	99784561
2	77542168
3	68542879
4	11789562
5	54789562
6	33535565
7	74145428
8	94852630
9	25893754
10	99784562
11	99784561

[shwetagupta · Accepted solution]

Hi Didier,

Though I am pretty new to Qlik sense but you can use pivot tables for finding the Same values. Attaching image of the pivot table on the data you have provided. !

I hope this will be of some help.

[didierodayo]

Thanks Gupta, I will stick to pivot table then but my challenge would be to write expressions that will identify similar records  (where first 4 digits are the same ). Do you have any ideas?

[shwetagupta]

Hi Didier,

You can try wildmatch / Match by providing the length to compare. for finding similar data.

I havent used it for whole table but I have used it for some particular data.