This example merges together a few email lists and then cleans and deduplicates the full list.
This example uses the following transforms to clean and process a list of emails:
–The Dedupe transform removes or combines rows with a duplicate value (i.e. email address).
–The Name Parser transform splits a name field into its constituent parts, i.e. first, middle, last, etc.
–If you want to get fancy, you can use the Find & Replace transform to make sure the email addresses are formatted correctly. In the provided example, we use regular expressions (regex) to make sure the email addresses are correctly formatted and remove ones that aren't.