WHERE multiple values in script

[stuwannop]

Hi All

Assume this is very straightfoward but I can't find the answer.

When running my script with the WHERE clause I can only pull data that matches one criteria e.g.

WHERE Opportunity = 'Won'

How do I run the script on two criteria in the same field - normally I would go:

WHERE Opportunity = 'Won' AND Opportunity = 'Open'

This seems a bit cumbersome, especially if I have a list of values all relating to the same field. Is this the only way of doing it or is there something like WHERE EXISTS or something?

Thanks

Stu

[nirav_bhimani]

Hi,

You can used the following expression

WHERE wildmatch('Opportunity','Won','Open');

Regards,

Nirav Bhimani

[swuehl]

LOAD OpportunityMatchField FROM OpportunityMatchTable;

LOAD

     ....

FROM ....

WHERE EXISTS(OpportunityMatchField, Opportunity);

[Sokkorn · Accepted solution]

Hi Stuart,

Match function will do this job.

Ex. Where Match(Opportunity,'Won','Open')

And if you want to use whildcard then use WildMatch() function

Ex. Where WildMatch(Opportunity,'*Won*','*Open*')

Regards,

Sokkorn

[stuwannop]

Thanks very much everyone that's really helpful.

Cheers.