Generates the count of rows in the dataset. Generated value is of Integer type.
NOTE: When added to a transform, the
COUNT function calculates the number of rows displayed in the current sample and are not applied to the entire dataset until you run the job. If you change your sample or run the job, the computed values for this function are updated. Transforms that change the number of rows in subsequent recipe steps do not affect the value for the already computed instance of
aggregate value: COUNT() group:postal_code
Output: Generates a two-column table containing the unique values for
postal_code and the count of records for that
There are no arguments for this function.
For more information on the
group parameter, see Aggregate Transform.
Example - Simple row count
derive value:COUNT() as:'row_count'