Hi I am looking for a doc on using IIF at Adobe campaign.
Does anyone know a good reference?
Solved! Go to Solution.
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:
Hi,
The Iif() sql expression? It's documented in its call:
This is analogous to decode() in Oracle:
Thanks,
-Jon
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?
Views
Replies
Total Likes
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:
Thanks DimaKudryavtsev
Views
Replies
Total Likes
Views
Likes
Replies