2 Replies Latest reply: Oct 15, 2015 9:38 AM by Andy Weir RSS

    Junk EMail

    virendra chawra



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











      Kindly suggest how to remove these from qlikview script.

        • Re: Junk EMail
          Friedrich Hofmann

          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,



          • Re: Junk EMail
            Andy Weir

            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.