PowerCenter
- PowerCenter 10.5.1
- All Products
IN(valueToSearch, value1, [value2, ...,valueN,]CaseFlag)
Argument
| Required/
Optional
| Description
|
---|---|---|
valueToSearch
| Required
| Can be a string, date, or numeric value. Input value you want to match against a comma-separated list of values.
|
value
| Required
| Can be a string, date, or numeric value depending on the type specified for the valueToSearch argument. Comma-separated list of values you want to search for. Values can be ports in a transformation. There is no maximum number of values you can list.
|
CaseFlag
| Optional
| Must be an integer or NULL.
Determines whether the arguments in this function are case sensitive. You can enter any valid transformation expression.
When CaseFlag is a number other than 0, the function is case sensitive.
When CaseFlag is 0, the function is not case sensitive.
When CaseFlag is a null value, the function returns NULL when it does not match the arguments in the function. Otherwise, the CaseFlag returns 1 when it matches the argument in the function.
Default is case sensitive.
|
IN( ITEM_NAME, ‘Chisel Point Knife’, ‘Medium Titanium Knife’, ‘Safety Knife’, 0 )
|
|
---|---|
|
|
|
|
|
|
|