Jump to content

multiple criteria in field calc


This topic is 5730 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi,

I was wondering if there is a faster shorter way to write a case statement with multiple criteria. For example:

case(

field_1 = "apple"

or

field_1 = "pear"

or

field_1 = "apple"

or

field_1 = "peach";

"fruit")

basically I wan to know if I can type field_1 = all the values for that result in it without having to type field_1 = for each value that will result if fruit. Like:

case(

field_1 = "apple", "peach", "pear";

"fruit")

I am just a lazy typer I guess, but can something like this be done?

Thanks in advance

Link to comment
Share on other sites

This topic is 5730 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.