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

    Junk EMail

    vir vir

      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
          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,

           

          DataNibbler

          • 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.

             

            Regards

             

            Andy