Hi All,
1. concatenated string from incoming files ex: firstName+LastName+email -->string1
2. concatenated string from recipient table ex:f irstName+LastName+email -->string2
We need to compare above two concatenated strings and if string1 is not equal to string2 we need to insert to a custom table say lead .If the strings are same we need to reject that record from incoming file.
We need to check for 8 concatenated strings in similar way for each incoming record .
How to implement it? Let me know if anyone have idea on it.
Thanks,
Maheswari