PowerCenter
- PowerCenter 10.5.6
- All Products
COUNT(value[,filter_condition] )
COUNT(*[,filter_condition] )
Argument
| Required/
Optional
| Description
|
---|---|---|
value
| Required
| Any datatype except Binary. Passes the values you want to count. You can enter any valid transformation expression.
|
*
| Optional
| Use to count
all rows in a transformation.
|
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.
|
COUNT( ITEM_NAME, IN_STOCK < 5 )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
COUNT( *, QTY < 5 )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
COUNT( * )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|