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.
Use an enrichment to left-join the tables on your concatenations, then split on empty key for right-side table, sending empty rows to an update activity for your custom table and the complement to an extract activity.