please i need to find all the duplicate customer including those conditions :
1- FName --> Fuzzy
2- LName--> Fuzzy
3-Date of birth --> Exact
In this part I made a mapping with the following elements:
Source --> KeyGenerator--> Matcht --> OutPt
The whole process works very well, and the results are very good.
Now I have to reverse between the last name and first name such that the last name becomes the first name and the first name becomes the last name
And, I want to integrate this principle on the same mapping to detect duplicates in with Fname and Lname and (last name and reverse first name):
Detect if the same customer who have multiple row on database with Fname and LName inversed
Thank you so much
I am afraid your question is not clear. Can you share your requirement specifically?