Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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;


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;

Highlighted
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!

Community Browser