Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amit_saini
Honored Contributor III

Filter Email Help

Hi Folks ,

I'm having data as per email ID's below:

aaron.simpson@abc.xyz.com

aaron.williams@abc.xyz.com

aaron.zhang@abc.xyz.com

abalazsova@bh.com

abdelmajid.afarsiou@pqr.com

I just want to filter my data based on my email Ids, want to see data only if email id is @abc.xyz.com

Please help!

Thanks,

AS

4 Replies
renjithpl
Valued Contributor

Re: Filter Email Help

May be this...

LOAD

  Field
FROM
...

Where match(SubField(Field, '@', 2), 'abc.xyz.com')>0;


Highlighted
sagarkharpude
Contributor III

Re: Filter Email Help

use wildmatch in script

if(wildmatch(email,'*@abc.xyz.com*')=1,1,0) as flag

and use this flag in front end

or you can also exclude the records while loading as below

load *

from Tablename where wildmatch(email,'*@abc.xyz.com*')=1;

Not applicable

Re: Filter Email Help

hi,

use in where clause

wildmatch(mailid,'aaron.simpson@abc.xyz.com','aaron.williams@abc.xvz.com')=1;

Regards

Vimlesh

Not applicable

Re: Filter Email Help

Hi,

Please try this:

load

..

from

where wildmatch(upper('abc@xyz.com'),'*@XYZ.COM')=1

Thanks!