DF issue with Lookup translation for contacts without no email address
I am importing records from a CSV file and the file contains many blank records without email address . we are using a Lookup translation to match the email address with user name from Contacts application .
But the problem is having blank email address in the file which comes from share point and if the email address is blank then it links multiple users in Application "Application" from contacts , which we don't want .
To avoid that we are building a calculation in source DF section to map the blank email address column with a value "email@example.com" but since this will not have a username in contacts application , therefore lookup translation brings warnings for these records after the DF completes . These warnings sometimes reaches more than 1k records having 3 pages .
I am looking for an idea and any another solution which can help me to avoid these warnings fo the above scenario mentioned .
Many thanks !
@AmitGupta, there’s not much you can do about that. There’s only a few options for the Exception setting that can be selected and I don’t think there’s an option to ignore.
Othere possibility is to create a dummy record in the Contacts application with that email address that returns a null values.