PowerCenter
- PowerCenter 10.5
- All Products
MAX(string[,filter_condition] )
Argument
| Required/
Optional
| Description
|
---|---|---|
string
| Required
| String datatype. Passes the string values for which you want to return a maximum string value. You can enter any valid transformation expression.
|
filter_condition
| Optional
| Limits the rows in the search. The filter condition must be a numeric value or evaluate to TRUE, FALSE, or NULL. You can enter any valid transformation expression.
|
MAX( ITEM_NAME, MANUFACTURER_ID='104' )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|