Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

qliklearnervir
New Contributor III

Junk EMail

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.

Tags (1)
2 Replies
datanibbler
Esteemed Contributor

Re: Junk EMail

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

ogster1974
Honored Contributor II

Re: Junk EMail

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