Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!
SOLVED

"Anyof" or "Contains" Construct in "IF" Conditionals?

Avatar

Level 10

I know the tedious, endless, nested-if solution to this, but wondered if there is an easier way.

Does WF have a construct/conditional for calculated fiends that would do this:

IF fieldName is ANYOF (A, B, C) then output "Cat"

ELSEIF fieldName is ANYOF (X, Y, Z) then output "Ferret"

ELSEIF fieldName is ANYOF (P, Q, R) then output "Pygmie Bunny"

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Kevin,

Sounds like a good fit for IFIN:

IFIN(fieldName,A, B, C,”Cat”,

IFIN(fieldName,X, Y, Z,"Ferret",

IFIN(fieldName,P, Q, R,"Pygmie Bunny",

“Red Herring”)))

Regards,

Doug

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi Kevin,

Sounds like a good fit for IFIN:

IFIN(fieldName,A, B, C,”Cat”,

IFIN(fieldName,X, Y, Z,"Ferret",

IFIN(fieldName,P, Q, R,"Pygmie Bunny",

“Red Herring”)))

Regards,

Doug

Avatar

Level 10

Perfect, just what I was hoping for!