IN macro
The IN
macro
is available in HCL®
Campaign and HCL
Interact.
Syntax
valuet IN (value1 AND value2
. . . .) or valuet IN subquery
Parameters
The first form permits using a list of values instead of a subquery.
The second form uses a subquery that is evaluated to produce an intermediate result, against which further processing can be performed.
Description
The IN predicate lets you use a list of values instead of a subquery, or will introduce a subquery.
Note: The
IN predicate has a negative version, NOT IN. The format for this is
identical to IN. NOT IN is true only if the provided value is not
found in the values returned by the subquery.
Important: When using
IN
in HCL
Interact,
you can only use the value IN (value1 AND value2 . . . .)
syntax.Examples
TEMP = IN(25, COLUMN(1...10))
Returns the specified column(s) from a data range |
TEMP = IN("cat", COLUMN("cat", "dog", "bird"))
Creates a new column named |
TEMP = IN(V1, V1) Creates
a new column named |
TEMP = IN(V1, V2) Creates
a new column named |