Dear Team,
I have created one data job and tried to load only duplicate records which is matching the Member Name, Father Name, Mother Name, Spouse Name (included null also), and Age (it can be vary).
One Sample:
Table: 1
Member Name Father Name Mother Name Spouse Name Age
Shakti Rabi Asha Null 25
Sourav Mohan Madhu Rasmita 30
Table2:
Member Name Father Name Mother Name Spouse Name Age
Shaakti Rabbi Asha Mohini 24
Note: In table 1, Member name Shakti and table2 Shaakti both are same.
What I have done described below,
First, I have appended table 1 and Table2
second, then created match code like
MEMBER NAME : Name (Definition), 80% Sensitivity
FATHER NAME : Name (Definition), 80% Sensitivity
Mother Name : Name (Definition), 80% Sensitivity
Age : Text (Definition), 80% Sensitivity.
I Want duplicate data like this:
Member Name Father Name Mother Name Spouse Name Age
Shaakti Rabbi Asha Mohini 24
Unique is:
Member Name Father Name Mother Name Spouse Name Age
Shakti Rabi Asha Null 25
Sourav Mohan Madhu Rasmita 30
But I got this:
Member Name Father Name Mother Name Spouse Name Age
Shakti Rabi Asha Null 25
Sourav Mohan Madhu Rasmita 30
Shaakti Rabbi Asha Mohini 24
Please suggest me How to handle Null values in Match Codes and how to identify Age code it may be +5 or -5 . if actual age is 20 some beneficiaries tried to fraud by age like 21 or 23.
please let me know, if required further details.
Thank You
Shakti
... View more
