topic Re: Junk EMail in QlikView

Junk EMail

qliklearnervir — Thu, 15 Oct 2015 13:26:19 GMT

Hi,

I am Loading data in qlikview but i am getting below given emails in data:

SSSSSS@mail.com

12345@abc.com

123456655

*******@gmail.com

Kindly suggest how to remove these from qlikview script.

Re: Junk EMail

datanibbler — Thu, 15 Oct 2015 13:32:31 GMT

Hi vir vir,

take a spear and kill them 😉

Would you mind providing a bit more information? that would make it much easier to help you do whatever you want to achieve.

I guess your QlikView_script merely loads the data, it does not add anything, does it?

So my guess would be those emails are in your data. You can of course filter those using a WHERE clause with your LOAD statement.

Best regards,

DataNibbler

Re: Junk EMail

ogster1974 — Thu, 15 Oct 2015 13:38:05 GMT

there doesn't look to be anything about the structure of the emails you could use to auto strip these out. In your application you are reporting on you should flag junk accounts and then exclude in your report load.

You could probably test and capture undeliverable mail messages as part of the registration/on boarding process on your mail server and do something with that to exclude them.

Regards

Andy