Recently, I set upon creating an e-mail list for a bi-monthly newsletter that my company Evolcon is going to send with updates on everythings related to Qlik and becoming a more data-driven organization. Of course, I used Qlik to parse and clean the e-mail list, and in the process, I used some not so common scripting functions that are fun to use.
The first step was to extract the e-mail information from Outlook and Gmail. You can easily find sites that will lead you through the process in Google. I used a Google script found on this blog and the Outlook extraction was pretty straight forward.
Parsing with subfield()
Once I extracted all the e-mail addresses from my e-mail and copied them to an Excel file, I started to write my script in QlikView to parse and clean the e-mails. The first challenge I encountered was parsing the domain from the e-mail. That’s a pretty simple job with the subfield() function, and the following function did the job:
SubField(Email,'@',2) as Domain,
Continue reading “Advanced Scripting – Creating an e-mailing list in Qlik”