Is there any doc on IIF usage?

Avatar

Avatar
Validate 1
Level 3
mustafau3722362
Level 3

Likes

17 likes

Total Posts

27 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
mustafau3722362
Level 3

Likes

17 likes

Total Posts

27 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mustafau3722362
Level 3

06-08-2019

Hi I am looking for a doc on using IIF at Adobe campaign.

Does anyone know a good reference?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 4
DimaKudryavtsev
Level 4

Likes

43 likes

Total Posts

44 posts

Correct reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
DimaKudryavtsev
Level 4

Likes

43 likes

Total Posts

44 posts

Correct reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
DimaKudryavtsev
Level 4

06-08-2019

Hi

There is no good manual for this function, but it is very basic and intuitive.

It looks like Iif(<expression>,<if expression truly, do this>,<otherways do that>)

Expressions can be any valid XTK expression, for example:

Iif(@myValue=1 and [nested/@value] >=2, "YES". "NO")

The following comparison operators are supported:

=, >, <, >=, <=, !=, IN, LIKE, NOT, IS NULL

Actions also can be anything, even another Iif() function. Ultimately, Iif will be converted to SQL expression CASE WHEN ... THEN ... ELSE ... END

p.s here are some resources:

Defining filter conditions

Advanced expression editing

Answers (3)

Answers (3)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

06-08-2019

Hi,

The Iif() sql expression? It's documented in its call:

This is analogous to decode() in Oracle:

Thanks,

-Jon

Avatar

Avatar
Validate 1
Level 3
mustafau3722362
Level 3

Likes

17 likes

Total Posts

27 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
mustafau3722362
Level 3

Likes

17 likes

Total Posts

27 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mustafau3722362
Level 3

09-08-2019

Avatar

Avatar
Validate 1
Level 3
mustafau3722362
Level 3

Likes

17 likes

Total Posts

27 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
mustafau3722362
Level 3

Likes

17 likes

Total Posts

27 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mustafau3722362
Level 3

06-08-2019

Thanks for the page wodnicki,

before I write here I saw that page.

The page does not provide real-life use cases and syntax for Adobe campaign.

Do you know any resource that shows various codes?